How to allow remote SQL connection to your site
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.
a WordPress rating system
No related posts.