Saturday, August 27, 2011

How to allow remote SQL connection to your site

August 4, 2009 by  
Filed under cPanel

Leave a Comment

Sometimes you may need to allow access of remote servers to your site’s mysql server. As mysql considers host for authentication anyone can’t connect from remote server unless allowed explicitly.

You can grant remote MySQL in the following steps:

- Login to cPanel

- Click Remote MySQL from Databases section

- Enter your connecting host IP in the box and click Add Host. You may use wild card (%) too. For example, you you write 192.168.0.%, it will allow any ip from 192.168.0.1 to 192.168.0.255.



GD Star Rating
a WordPress rating system
Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on DotNetKicks.com
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)

No related posts.

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!
Click here to cancel reply.