Connect to a remote MySQL server

Log into MySQL as a root user by using the following command:

At the mysql prompt type the following replacing databasename with the actual database name, dbusername to the actual database user name, and password to the actual password.

GRANT ALL PRIVILEGES ON databasename.* TO dbusernamee @'%' IDENTIFIED BY 'password';

After this you should be able to connect to the MySQL database remotely using any third party software like MySQL front

Share on Twitter
Share on Facebook