Mysql.sock and remote access

Discussion in 'Server Operation' started by Samik, Oct 6, 2011.

  1. Samik

    Samik New Member

    Hello!

    I am writing in order to get help about my problem with mysql server (on debian). Everything works well when server is "local only", but when I try to make it remote accessable i get some problems...
    When I change "bind-address" in /etc/mysql/my.cnf to '*' or '%' (or any valid IP address like my own) i get following errors:

    Code:
    /etc/init.d/mysql[5801]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
    /etc/init.d/mysql[5801]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
    /etc/init.d/mysql[5801]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
    /etc/init.d/mysql[5801]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
    /var/run/mysqld folder is empty

    Thanks for any replies,
    Samik
     
  2. falko

    falko Super Moderator ISPConfig Developer

    Can you post your /etc/mysql/my.cnf?

    What's the output of
    Code:
    netstat -tap
    ?
     
  3. Samik

    Samik New Member

    I'm using 3305 port instead of 3306 because i had some problems with it.

    It says nothing about 3306, 3305 ports or mysql.
     
    Last edited: Oct 7, 2011
  4. falko

    falko Super Moderator ISPConfig Developer

    Can you completely comment out the bind-address line and restart MySQL?
     
  5. Samik

    Samik New Member

    Yeah, It works!

    Thanks! :)
     

Share This Page