How to enable MySQL for remote login

I have MySQL installed in the bitnami directory structure. Change the directory structure based on where you install is located.

At the server console, edit the file /opt/bitnami/mysql/my.cnf and find the line containing

bind-address=127.0.0.1

Comment out this line by placing a hash (#) symbol at the beginning, so that it looks like this:

#bind-address=127.0.0.1

Save the file.

At the server console, allow remote access to the MySQL database server using the MySQL command line client. Use the following command, remembering to replace PASSWORD with the application password from the first step:

/opt/bitnami/mysql/bin/mysql -u root -p -e "grant all privileges on *.* to 'root'@'%' identified by 'PASSWORD' with grant option";

When prompted for a password, enter the password.

Restart the MySQL server:

sudo /opt/bitnami/ctlscript.sh restart mysql