Yes! it is possible. For this you have to allow remote access from your
control panel, by adding your IP to the access hosts in mysql screen
there. If you do not have a fix IP at your end you can use % as wild
card and allow remote access from anywhere, which is not advised for security reasons.
Then for remote connection you have to use the server IP or your
domain IP or domain name instead of localhost in your script/program.
For example, to connect remotely via 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.
- 59 Kasutajad peavad seda kasulikuks
Seotud artiklid
What is MySQL?
MySQL is a very robust database server. It is often used to deliver dynamic content to sites...
How do I connect to and use MySQL?
Please login to your control panel and follow these steps to create the database, user and its...
How do I create/delete/edit my databases and users?
All administration of your MySQL databases and users can be done through our convenient web...
Which version of MySQL is available?
The shared/reseller servers are setup with MySQL 5.2.x. If you need to use newer version i.e....
