Apparently, my.cnf (/etc/mysql/my.cnf) shipped with
bind-address = 127.0.0.1
The reason being
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
Okay, but I need to access mysql from another server. Anyway, just change this to your IP and it should be good.
Don't forget to restart mysql
sudo /etc/init.d/mysql restart
source: http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html
third comment.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment