Cant connect to MYSQL database from Dreamweaver

[toyito]

Hi.

I have a Breezy Badger ISPConfig runnig all ok, im trying to connect to a database from Dreamweaver MX2004, but i cant, i use the following settings in connection:

Connetion:Test
MySQL server: www.xxx.com
User: Web9_u4 or root
Password: mypass
Database: Web9_db4
I allways get an "2013 Lost Connection to MYSQL server during query" error.
Can you help me to fix this problem pls.

Hector

PD i´ve set remote access in ISPConfig to yes for this database.

[toyito]

Hi.

Me again...i tryied to connect from the odbc connector and got same results.....pls help me

Hector

PD [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'xxx.com' (10061)

[till]

Is mySQL listening on all IP addresses? Please post the output of:

netstat -tap

[toyito]

Hi Till

Output of netstat -tap

Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 localhost.localdo:mysql *:* LISTEN 6290/mysqld
tcp 0 0 *:81 *:* LISTEN 6488/ispconfig_http
tcp 0 0 server1.example.:domain *:* LISTEN 15368/named
tcp 0 0 localhost.locald:domain *:* LISTEN 15368/named
tcp 0 0 *:ftp *:* LISTEN 4855/proftpd: (acce
tcp 0 0 localhost.localdoma:953 *:* LISTEN 15368/named
tcp 0 0 *:smtp *:* LISTEN 4938/master
tcp6 0 0 *:imaps *:* LISTEN 6200/couriertcpd
tcp6 0 0 *op3s *:* LISTEN 6235/couriertcpd
tcp6 0 0 *op3 *:* LISTEN 6215/couriertcpd
tcp6 0 0 *:imap2 *:* LISTEN 6180/couriertcpd
tcp6 0 0 *:www *:* LISTEN 12109/apache2
tcp6 0 0 *:ssh *:* LISTEN 6428/sshd
tcp6 0 0 ip6-localhost:953 *:* LISTEN 15368/named
tcp6 0 0 *:https *:* LISTEN 12109/apache2
tcp6 0 1796 server1.example.com:ssh ::ffff:10.22.0.172:4845 ESTABLISHED15607/0

[falko]

Originally Posted by toyito

tcp 0 0 localhost.localdo:mysql *:* LISTEN 6290/mysqld

MySQL is listening only on 127.0.0.1.
Please comment out the line

bind-address            = 127.0.0.1

in /etc/mysql/my.cnf and restart MySQL.

[toyito]

Thank you....thanks a lot

Hector