修改my.cnf:[mysqlld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock# Disabling symbolic-links is recommended to prevent assorted security riskssymbolic-links=0log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pidsocket=/var/lib/mysql/mysql.sockcharacter_set_server=utf8[cl...【阅读全文】
首先使用Navicat连接mysql,输入配置后保错:1130-Host‘XXX.XXX.XXX.XXX’ is not allowedto connect to this MySQL server 发现这是权限的问题,远程服务器无权限登录MySQL。那就修改权限: GRANT ALL PRIVILEGES ON *.*...【阅读全文】