A few days ago as I was trying to modify a VB.NET application currently using MS ACCESS as DB to make it access a remote MySql database I had created on my VPS, I found that it was more difficult than it actually seemed at first hand.
A few days later, I found the solution and that wasn’t easy so I said to myself this could be useful to you too so here is how you need to proceed if you want to access a distant or remote MySql DataBase.
The principle is simple, you need to tell your mysql server that remote IPs (not only local ones) CAN access the DB because those connexions are blocked by default. This is something you can do just by edition the config file “my.cnf” so you need to have access to all your server options which is not always the case on a shared hosting.
For detailed instructions, take a look at this page where everything
is explained step by step:
http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html
RSS feed for comments on this post · TrackBack URI
Leave a reply