Topic: Dreamweaver MX 2004, PHP, MySQL Error

[aussiebob]

I'm running SME 6.1 and have set up an Ibay for a web app I'm developing. I've enabled cgi when I created the bay, and set up the Ibay as my testing server in Dreamweaver using ftp to ../../ibays/mixingdesk/html/. This works when creating static web pages.

I've also created a MySQL database and set up a user for it (initially from the MySQL command prompt, then with PHPMyAdmin as a sanity check). I can't get Dreamweaver to connect to the database.

When I try I get a "2003 Can't connect to MySQL server on 'compie' (111)" error.

I suspect this is an host/authentication error, but no privelege changes have worked (set user to localhost only, granted %, granted specific IP). I get the feeling there's something basic I'm missing...

Any ideas?


Thanks,


Bob

[jfarschman]

Bob,

  I've never tried this, but as I recall, DreamWeaver wants to connect to port 3306 for development purposes.  This is the port it needs to talk with the mysql daemon.  When I do a netstat -tupan on the command line I can see it listening

Code: [Select]


tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      2233/mysqld


So... On my server I just tried to telnet to this port:

Code: [Select]

Peculiar:~# telnet 192.168.2.50 3306
Trying 192.168.2.50...
Connected to 192.168.2.50.
Escape character is '^]'.
QHost 'pc-00100.hitechsavvy.com' is not allowed to connect to this MySQL serverConnection closed by foreign host.


So... I'm not allowed in.  Generally, I give myself all kinds of permissions.

Have you searched this board for answers?  I'm curious about this one.  I'd search for DreamWeaver and see what you come up with.  Please let me know.  jay@hitechsavvy.com
 

[genzil]

You'be both made the same mistake.  You've allowed the user to connect to mysql but mysql its self doesn't allow you to connect from any where but localhost. ie the machine it's running on.

Have a look at this post http://forums.contribs.org/index.php?topic=22748.msg90276#msg90276

[aussiebob]

Genzil, your advice solved the problem so thanks for that. It does surprise me though - I'd always thought that Dreamweaver put the PHP code to connect to MySQL on the server, then ran it from there. Obviously that's not what happens.

Anyway, thanks for your help. I owe you a beer or two...


Bob