top of page
Search

How to enable MySQL for remote login

  • Writer: Innofoundry
    Innofoundry
  • Jan 8, 2018
  • 1 min read


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

 
 
 

Opmerkingen


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

Thanks! Message sent.

bottom of page