For importing large databases we recommend using tools such as MySQL Query Browser.

Before being able to connect remotely you will have to:

  1. Create a database and grant a user with all rights to it;
  2. Add your local IP in the allowed IPs to access the MySQL service.

All of the above can be done from the MySQL manager in cPanel.

Was this answer helpful? 6 Users Found This Useful (191 Votes)

Most Popular Articles

What is the MySQL Default Hostname?

All of our servers are configured with MySQL listening on localhost.  If you install from...
How can I change my MySQL database collation?

Usually you will be interested in changing your MySQL collation in order to solve problems with...
What type of databases do you support? MySQL, PGSQL?

All Lithium Hosting servers support MySQL and PostgreSQL databases. Also with any of our hosting...
Is SQLite supported?

SQLite is a software library which implements an SQL database engine. SQLite and PDO_SQLite are...
How to optimize a MySQL database in PhpMyAdmin

It is always a good idea to keep your databases' tables optimized. Fortunately, making this...