I found this error after an upgrade to 8.04 server. It seems the default my.cnf file is only listening on the localhost (use netstat -l -t -p to determine) & look for the mysql entry that reads:
tcp 0 0 localhost:mysql ... If you have this, then you are only listening on the localhost. The fix was to comment out the line in my.cnf that reads bind-address = 127.0.0.1 byt prefixing the line with a #. This allows the machine to listen on the external ports as well. The netstat should show a line that reads as follows: tcp 0 0 *:mysql ... Hope this helps. -- [gutsy] mysql-admin can't connect to remote mysql server https://bugs.launchpad.net/bugs/155274 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
