mysql error - db not accessible.. from outside

Discussion in 'Installation/Configuration' started by pontifex, Sep 28, 2005.

  1. pontifex

    pontifex New Member

    Hi everyone,
    i turned on the option mysql db accessible from outside, but it is not reachable. current system ist debian sarge with mysql 4.1 what am i doing wrong?

  2. falko

    falko Super Moderator ISPConfig Developer

    Make sure the firewall on your ISPConfig box allows connections to port 3306 (MySQL).
  3. pontifex

    pontifex New Member

    hi, as far as it is concerend i did add the port 3306 to the firewall interface of ispconfig but it did not work.

    nmap shows, that mysql listens on port 3306. when i looked at the howtos for sarge. everytime mysql 4.0 was mentioned. the cnf fo 4.1 differs a little bit. so where to add the #skip-networking info there? by default there is no such line in the cnf file...

  4. falko

    falko Super Moderator ISPConfig Developer

    Can you post the output of
    netstat -tap
    If you have the following line in /etc/mysql/my.cnf:
    bind-address            =
    comment it out and restart MySQL.
  5. pontifex

    pontifex New Member

    the error was caused by the bind to address After commenting it out, it works fine now...



Share This Page