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.
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)
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
MySQL is listening only on 127.0.0.1. Please comment out the line Code: bind-address = 127.0.0.1 in /etc/mysql/my.cnf and restart MySQL.