New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Cant connect to remote mysql database?
I have a LEB which im attempting to offload my mysql database to webhost i have with unlimited databases. I have setup my VPS's address to be allowed remote to the offloaded mysql database, but still i cant connect to it?
To clarify:
LOWENDBOX - > Webhost mysql database
Is there any settings i should do to my vps to allow it to access remote databases?
Im running ubuntu 12.04...
Comments
Telnet to the remote IP / port to confirm/deny that its working
Contact your web host, some provider need your IP address being whitelisted to use the remote MySQL.
Make sure to have your mysql hosting provider have tcp port 3306 allowed for your VPS. You can check this on your vps with telnet command
telnet mysqlproviderIP 3306If your host uses cPanel you need to add the IP in the Remote MySql section of cPanel.
Got it working, thanks guys