How can I access mysql database remotely?

Under the mysql header in Cpanel, select 'manage mysql'

Then scroll down to the 'access hosts' input field. Place your IP address (your local computer not the server)in there and click 'add host'.

This should allow you to remotely connect using your database username/password.

  • 4 Users Found This Useful
Was this answer helpful?

Related Articles

What are the information_schema tables I see when viewing my database?

INFORMATION_SCHEMA provides access to database metadata. Metadata is data about the data, such...

How can I backup a database using phpmyadmin?

Backing up your database in Phpmyadmin is accomplished by doing the following: 1) Once you have...

How do I add a mysql database in Cpanel?

To create a MySQL database: - Go to 'Manage Mysql' under the database header in Cpanel - In the...

How do I backup a MySQL database using compression?

In this section, we will show you how to make a backup (also known as exporting) of your database...