Access MySQL database from remote server

[rtaylor]

I'm having trouble accessing MySQL from a remote DA server. I've set this up successfully so that a DA VPS can access MySQL on a dedi with DA, but I've not been able to make this work from a 3rd server (DA dedicated). Here are the instructions I've followed that worked:

http://help.directadmin.com/item.php?id=140
http://help.directadmin.com/item.php?id=45

Using the same instructions, I cannot get server 3 to connect to server 1 MySQL. Here is the error message:

ERROR 1045 (28000): Access denied for user 'da_admin'@'1.2.3.4' (using password: YES)

1.2.3.4 is a placeholder for the actual IP of the dedicated DA server with the MySQL database I need to connect to.

I've carefully followed the knowledgebase instructions several times, and of course verified that port 3306 is open in the firewall. Any ideas?

 

[zEitEr]

You might need to read this http://help.directadmin.com/item.php?id=308

 

[toml]

Did this part of the instructions work for you?
mysql -uda_admin -p --host=4.3.2.1

If not then most likely, either the password wasn't set properly for the [email protected] entry in the privilege table. Make sure that works first before trying to get phpmyadmin to work remotely.

 

[rtaylor]

You might need to read this http://help.directadmin.com/item.php?id=308

I'm using da_admin with the confirmed correct password (works locally and works remotely from DA VPS, but doesn't work from another dedi DA server).

Did this part of the instructions work for you?
mysql -uda_admin -p --host=4.3.2.1

If not then most likely, either the password wasn't set properly for the [email protected] entry in the privilege table. Make sure that works first before trying to get phpmyadmin to work remotely.

That's the exact place where I am stuck with the error I mentioned.

 

[toml]

If you have access to phpmyadmin on the MySQL dedicated server, then try changing the password for the [email protected] entry, or do it manually, just change it to the password you expect it to be. It may not have been set properly when doing doing the GRANT command. You may also want to look at the /var/lib/mysql/$HOSTNAME.err (assuming that is where the MySQL db files are located) and see if there are any other errors logged.

 

[rtaylor]

If you have access to phpmyadmin on the MySQL dedicated server, then try changing the password for the [email protected] entry, or do it manually, just change it to the password you expect it to be. It may not have been set properly when doing doing the GRANT command. You may also want to look at the /var/lib/mysql/$HOSTNAME.err (assuming that is where the MySQL db files are located) and see if there are any other errors logged.

THANK YOU! I didn't even think of looking up the [email protected] entry in phpMyAdmin, and when I put the password that I expected it to be in there and saved, then I could make the remote connection. I really appreciate the help!

Cheers,
Rick