MySQL – Open MySQL for Remote Connection

Last updated on March 29th, 2018 at 02:31 pm

cp /etc/my.cnf /my.cnf.bak
for check
nano /my.cnf.bak
nano my.cnf
[mysqld]
#bind-address = 127.0.0.1
general_log = 0
general_log_file = /var/log/mysql/mysql.log
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

service mysqld restart

Leave a comment

Your email address will not be published. Required fields are marked *