MySQL Offline problem.

Discussion in 'General' started by Wader, Oct 6, 2011.

  1. Wader

    Wader New Member

    Hello,

    I've currently got a bit of a problem with my server. ISPConfig is showing my mysql server as offline which in turn is causing my mail and ftp to not work. However my MySQL is online as i can login to the mysql via. ssh and also phpmyadmin is working fine to which i can login with the root account and non-privileged users.

    What can i do to debug and find the cause of the problem?

    Thanks in advance, Wader.
     
    Last edited: Oct 6, 2011
    Wader, Oct 6, 2011
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Most likely your mysql server is not listening on localhost. Please post the output of:

    netstat -tap | grep mysql
     
    till, Oct 6, 2011
    #2
  3. Wader

    Wader New Member

    This is the output. I did change the bind-host of the mysql the other day to allow remote connecting.

    Is it possible to do make mysql listen on the localhost and the IP?

    Code:
    tcp        0      0 velocity.iwader.c:mysql *:*                     LISTEN      1797/mysqld
     
    Wader, Oct 6, 2011
    #3
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Yes, just comment out the bind directive by adding a # in front as described in the perfect setup guides.
     
    till, Oct 7, 2011
    #4

Share This Page