cancel
Showing results for 
Search instead for 
Did you mean: 

VPS - MySQL Connection

CX
Grafter
Posts: 745
Thanks: 2
Registered: ‎16-09-2010

VPS - MySQL Connection

I have MySQL installed on a VPS at 94.x.x.x (running on standard port 3306). My Plusnet IP address is 87.x.x.x
When I try to connect to the VPS with a valid username and password (I know, I know, we should use an SSH tunnel...) to 94.x.x.x I receive an error message "SQL Error 1045: Access denied for user 'myusername'@'87.x.x.x' (using password: YES)".
Remote connections are working on the VPS because I can connect to it without trouble from a KC broadband connection. It's just the Plusnet connection which gives an error message coming from the wrong IP address (and why is it doing this?). It doesn't matter which app I use - I tried HeidiSQL on my Windows machine and MySQL Workbench on my Linux server. Both gave the same error. I can SSH into the VPS from the Plusnet connection, and access Webmin.
Edit: Restarted MySQL server on the VPS again and it's working.  Huh