Cant connect to MYSQL database from Dreamweaver

Discussion in 'Installation/Configuration' started by toyito, Feb 1, 2006.

  1. toyito

    toyito New Member

    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.
     
  2. toyito

    toyito New Member

    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)
     
    Last edited: Feb 1, 2006
  3. till

    till Super Moderator Staff Member ISPConfig Developer

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

    netstat -tap
     
  4. toyito

    toyito New Member

    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 *:pop3s *:* LISTEN 6235/couriertcpd
    tcp6 0 0 *:pop3 *:* 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
     
  5. falko

    falko Super Moderator Howtoforge Staff

    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.
     
  6. toyito

    toyito New Member

    :) :)
    Thank you....thanks a lot

    Hector
    :) :)
     

Share This Page