MySQL Hosting

MySQL Databases

19-08-2018

MySQL Hosting

Can I connect remotely to MySQL database?

For this you have to allow remote access from your control panel, by adding your IP to the access hosts in MySQL screen. If you do not have a fixed IP at your end you can use % as a wild card and allow remote access from anywhere.

Then for the remote connection you have to use the server IP or your domain IP or the domain name instead of localhost in your script/program.

For example, to connect remotely via the MySQL command line utility:

mysql -h x.x.x.x -u USERNAME -p DATABASE

(where x.x.x.x is your server ip, USERNAME is the db user, and DATABASE is the database name)

NOTE: Whenever an IP/Host is added or removed from the Access Host field, the privileges need to be reassigned to the database user on that database otherwise it will produce Access Denied error.

Check a Domain is Available:
www.
Click Here to Check Domain









Sign Up - Click Here

Hosting Plans From:

Budget Hosting €3.99/mth
Business Hosting €5.99/mth
E-Commerce €9.99/mth
Reseller Hosting €19.99/mth
VPS Hosting €29.99/mth

Full Domain Price List

Click here to enter shop

 

Latest News -