Sometimes, you want to manage your database from your web server without login to it. There is a way to do this is enabled Remote Access MySQL. So how do it?
1. Change MySQL configuration
By default, Remote Access MySQL was disabled, you need to enable this option via command:
sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf
Add comment (#) character inline #bind-address = 127.0.0.1. Save and close.
Restart your mysql service
sudo service mysql restart
2. Set access remotely permission for the root account.
Login to mysql server and run command below:
mysql -u root -p
GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘your_password’ WITH GRANT OPTION;
Now, on the remote machine, I can login to the mysql server.