To add yourself to the whitelist so that you can connect to mysql remotely using admin tools such as phpMyAdmin, Navicat, MySQLFront or MySQL-Admin follow the below steps:
- Log into your control panel at www.yourdomain.com/cpanel
- Click on the 'Remote MySQL' under the 'Databases' menu
- Type % in the Host field
- Click on 'Add Host'
You should now be able to connect successfully.
To restore a MySQL database please follow the below steps:- Login to your control panel...
The command line option from SSH is: mysql -d -p database_name > file.sql. Where...
There are two different ways to connect to a MySQL database: Locally - from a script on the...
To import a database follow the below steps:I have a backup of my database that I need to...
There are two ways to back up your MySQL databases. You can use the backup utility in your cPanel...