Search

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

Need more details?
Contact us

We are here to assist.

email : info@innofoundry.com 
phone : +1 (415) 669-4289

Location: Austin, Texas, United States

© 2009 - 2018 Innofoundry LLC. 
Innofoundry® is a Registered Trademark of Innofoundry LLC