Remote SQL connections

[Time]

I have a website and a VPS, I want the website to be able to access the SQL databases (version 5.5.8) running on the VPS.

I've tried using the GRANT ALL PRIVILEGES command, it didn't seem to do anything.

command:

GRANT ALL PRIVILEGES ON *.* TO 'SITE'@'178.239.62.125' IDENTIFIED BY 'MY-PASSWORD';

Error from the webpage trying to access the databases:

Error: Unable to connect to MySQL server. MySQL server is offline or you dont have access to connect to it or username/password is wrong.

MySQL reported: Lost connection to MySQL server at 'reading initial communication packet', system error: 110.

Suggestions:
1) Recheck your MySQL username and password in website's config.php file.
2) Try start MySQL server on your host, maybee there is no connection.
3) Give 'admin' rights to user (SITE) that you using to connect to MySQL.

Thanks.

Time Reviewed by Time on 19th Mar 2011. Remote SQL connections I have a website and a VPS, I want the website to be able to access the SQL databases (version 5.5.8) running on the VPS. I've tried using the GRANT ALL PRIVILEGES command, it didn't seem to do anything. command: GRANT ALL PRIVILEGES ON *.* TO 'SITE'@'178.239.62.125' IDENTIFIED BY 'MY-PASSWORD'; Error from the webpage trying to access the databases: Rating: 5

[NewEraCracker]

have you tried phpmyadmin?
Is port 3306 firewalled?

[okone]

You just need to make sure the mysql server on the vps is set to allow connections from external addresses.

Check mysql.cf, most likely it is only set to bind to localhost.

You also need to allow anyhost to connect to it and this can be done via phpmyadmin.

[Time]

I've opened up the ports on the firewall.

I can't seem to find the right mysql.cf file, what directory is it in?

[Lock Down]

/etc/my.cnf

[Time]

Forgot to add, it's a Windows server 2008 VPS.

[snowmanrene]

okay.
Format, install Linux

[Lock Down]

Look in your mysql folder for a file called my.ini I believe.