I can't log into MySQL from a remote computer using a MySQL admin tool.

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.

  • 25 Users Found This Useful
Was this answer helpful?

Related Articles

How do I restore a MySQL database?

To restore a MySQL database please follow the below steps:-’ Login to your control panel...

I would like to dump the Table Structure for my MySQL Database, but none of the data.

The command line option from SSH is: mysql -d -p database_name > file.sql. Where...

What are the Basic Connection Settings for MySQL?

There are two different ways to connect to a MySQL database:’ Locally -’ from a script on the...

How do I import a MySQL database?

To import a database follow the below steps:I have a backup of my database that I need to...

How do I create a MySQL backup?

There are two ways to back up your MySQL databases. You can use the backup utility in’ your...