How do I enable remote access to MySQL database server on Plesk?

Since Plesk 8 MySQL users and databases are created with permissions that allow access to the database from outside. In previous Plesk versions MySQL users and databases are created with permissions that allow to access the database from localhost only. However, sometimes you need to provide the remote access.

To assign the full privileges to admin user on all the databases on server running plesk.

1. To go to mysql prompt use command

# mysql -u admin -p`cat /etc/psa/.psa.shadow`

2. To assign the admin user on all the databases on server running plesk

mysql > GRANT ALL PRIVILEGES ON *.* TO 'admin'@'1.1.1.1' identified by 'PASSWORD';

Where,

*.           => For all the databases on the server
admin    => User Name to be used with full privileges
1.1.1.1   => The Ip address of the machine from which you wish to access all the db’s ( Remote Host )

To verify The connectivity of the DB from remote host run the following command.

mysql -h 2.2.2.2 -u admin -p yourpassword

Where,

2.2.2.2   => Is the mysql server IP Address