Friday, May 26, 2017

How to allow remote connection to mysql

By default, In MySQL, remote access is disabled. 
First, execute below SQL command to enable all the privileges. Here, I'm using "root" as the user and "abc123" as the password.
 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'abc123' WITH GRANT OPTION;
 FLUSH PRIVILEGES;
Then open /etc/mysql/my.cnf from  Unix/OSX systems. If it's a Windows system, you can find it in the MySQL installation directory, usually, something like C:\Program Files\MySQL\MySQL Server 5.5\ and the filename will be my.ini

And then find the following line from my.inf and comment out .
Change line
 bind-address = 127.0.0.1
to
 #bind-address = 127.0.0.1
Then, restart MYSQL server for the changes to take effect.

No comments:

Post a Comment