Remote logins to mySQL server as "root" user????

[JVRudnick]

Hey support...

I am having major troubles, in that I can NOT connect remotely to my mySQL server running on my ded server at ThePlanet.

As I understand things, mySQL was installed via Plesk by support there, when they originlly set up this server back in Dec/04. Subsequent to that, I ordered an upgrade to the Plesk version, and they did that as well.

The mySQL dbase server runs fine, but I am unable to connect to it remotely. I am trying to use the mySQL Administrator with the following credentials....
Server Host : IP number
Port : 3306
UserName : Plesk login name
Password : Plesk password

This data on what to use comes from the Plesk site itself from the SWSoft knowledgebase. Normally, the UserName would be "root" but apparently, installing mySQL via Plesk changes this. So I am attempting to use my working name/password that I use when I log into Plesk on that server.

The above creds do not work...when run, I get an error that says "Could not connect to the specified instance. MySQL Error Number 2003."

What do I need to use to be able to connect to the mySQL dbase remotely please at the "root" or superuser level?

Jim

 

[vekna]

1. Plesk use 2 MySQL servers on 3306 and 8306 ports
2. You should use 'admin' instead 'root' - it is Windows =))
3. To connect to Plesk admin MySQL you should use 'admin', plesk admin password and port 8306
4. To connect to clients MySQL you should settings which you added in plesk server database mangement.

 

[JVRudnick]

Vekna!! Thanks so much...

Your "to the point" reply has enabled me to do the following...

When I log into the server via RDC, open up MySQL Adminstrator, and then use the two logins you noted they both work fine....thanks so much!!!

To connect to Plesk admin MySQL you should use 'admin', plesk admin password and port 8306 - WORKS !!!

To connect to clients MySQL you should settings which you added in plesk server database mangement -- WORKS TOO!!!


That is when I'm "ON" the server itself, they work fine, ie when I use "localhost" for the server name.

When I try to conn to the same two accounts from my desktop, again using MySQL Administrator, I get the same error 2003. For the admin account I tried using the IP - failed, and for the client account, I tried their domain name - failed. I used the same name/pw that worked fine when I'm "on" the server, note...but still error 2003s..

WHy might that be? IS this app not made to conn remotely???

Jim

 

[FFCus]

If I recall correctly, you need to use SSH tunneling for remote MySQL access. I remember I looked into it, but decided to go the extra step to use remote desktop for admin with a GUI application.

...one less place to have to worry about security holes.

Some more info...
http://dev.mysql.com/doc/refman/5.0/en/windows-and-ssh.html

 

[JackL]

Some more tricks:

Use command line or any front-end to change allowed hosts from localhost to % (any), but it is very dangerous because any password generator can crack your password

John S.G.

 

[Rubal]

Originally posted by JackL
but it is very dangerous because any password generator can crack your password

John S.G.

Not necessarily if you really keep a strongPassword for mySQL root user.