Mysql remote connections

Ask questions about dedicated servers here and we and other users will do our best to answer them. Please also refer to the self-help section for tutorials and answers to the most commonly asked questions.
Post Reply
Skorch
New to forums
New to forums
Posts: 1
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Tue Nov 19, 2013 5:34 am

Mysql remote connections

Post by Skorch »

I'm running mysql on xampp on my VPS, while my webhost site is connecting to the database on the vps. I've already tried enabling remote connections, but the webhost just doesn't want to connect. It says it has no permission.

http://viciousms.net/ is the webhost
it cant connect to my xampp mysql db
User avatar
Spray
Former staff
Former staff
Posts: 630
Joined: Wed Dec 28, 2011 10:41 pm
Location: Oregon

Re: Mysql remote connections

Post by Spray »

Does your MySQL user have external permissions setup? Something like 'user'@'%'

You'll also need to make sure the following line isn't in your MySQL config file:

Code: Select all

skip-networking
And double check that you have a firewall rule allowing incoming connections on TCP port 3306
Post Reply