Ubuntu
mysql-admin package

[gutsy] mysql-admin can't connect to remote mysql server

Bug #155274 reported by Krunoslav Husak
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
mysql-admin (Ubuntu)
Invalid
Undecided
Unassigned

Bug Description

Binary package hint: mysql-admin

MySQL Administrator can't connect with remote mysql server.

Instead, this error message is returned:
Could not connect to host 'remote.server'.
MySQL Error Nr. 2003
Can't connect to MySQL server on 'remote.server' (111)

Where remote.server is FQDN for remote server.

However, MySQL Administrator can connect to localhost mysql server!
Also, when trying to connect to remote server with mysql-admin from feisty, I don't receive this error and everything works.

Revision history for this message
de_pele (depele) wrote :

Same Here.

Please fix it...

Revision history for this message
Koen (koen-beek) wrote :

Works for me on gutsy amd64 - mysql-admin 1.2.5rc-2ubuntu3

Revision history for this message
rshane (info-basexvi) wrote :

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.

Revision history for this message
Daniel T Chen (crimsun) wrote :

Is this symptom still reproducible in 8.10?

Changed in mysql-admin:
status: New → Incomplete
Revision history for this message
Pedro Villavicencio (pedro) wrote :

We are closing this bug report because it lacks the information we need to investigate the problem, as described in the previous comments. Please reopen it if you can give us the missing information, and don't hesitate to submit bug reports in the future. To reopen the bug report you can click on the current status, under the Status column, and change the Status back to New. Thanks again!.

Changed in mysql-admin:
status: Incomplete → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.