I found this topic (#26705) while trying to resolve my problem, which was the inability to log in to the remote database server using MySQL Administrator to perform a backup of a WordPress database for a blog hosted on lunarpages.com. Here is what I did to solve the problem.
I am using MySQL for a WordPress blog hosted by lunarpages.com. I installed WordPress using Fantastico from the lunarpages.com CPanel. Regrettably, CPanel and Fantastico have defaults which caused problems.
CPanel/Fantastico prefixes the lunarpages.com username ("foo") to whatever username and database name the user specifies when creating the database. If no name is specified, the default is "wrdp1". Moreover, CPanel/Fantastico by default makes the user name the same as the database name. So if you specify "bar" as the WordPress database name and your lunarpages.com username is "foo", the WordPress user name will be "foo_wrdp1". Likewise, the database name will be "foo_wrdp1".
I am running a Linux system, namely, Debian "sarge". I installed the package "mysql-admin", which is the MySQL Administrator. After several unsuccessful attempts to connect to the database server at lunarpages.com, I found in this topic a suggestion to change the username to a value distinct from the database name. So, using "MySQL Account Maintenance" in CPanel, I added user "bar", which CPanel turned into "foo_bar". So, with username "foo_bar" and servername "mydomain.com" (omitting the "www."), I was able to connect to the MySQL server at lunarpages.com, using MySQL Administrator.
My primary goal was to backup the database "foo_wrdp1". However, I discovered that the only database which mysql-admin could see was an empty data base with the schema (that is, name) "test". The problem turned out to be that user "foo_bar" had not been added to the user list for the database. So, I went back into "MySQL Account Maintenance" in CPanel and add user "foo_bar" to the user list for database "foo_wrdp1". When I exited and then restarted mysql-admin, I found "foo_wrdp1" listed as a schema, and now I am able to inspect the tables of the schema and perform a backup.