Results 1 to 1 of 1
Thread: Remote MySQL Access in Linux
04-11-2016, 05:12 AM #1
- Join Date
- Oct 2015
Remote MySQL Access in Linux
We can enable remote access to MySQL by doing some small changes.
Edit MySQL configuration file /etc/my.cnf and comment out following parameters
#bind-address = 127.0.0.1 #skip-networking
Restart the MySQL service.
Now you will require to assign privilege to the database user and database for remote access. Use below query in mysql terminal
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'xx.xx.xx.xx' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
Then flush the privileges