Save 15% on Instant Deploy Bare-Metal Servers in 26 Global Markets with Coupon Code: EdgeSave

Connect to a remote MySQL server

Log into MySQL as a root user by using the following command:
mysql -uUSERNAME -pPASSWORD

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