解决windows IP连接linux mysql时出现的权限问题
允许指定IP访问 :
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.3.18' IDENTIFIED BY 'root' WITH GRANT OPTION;
不需要刷新授权表
ubuntu:vim /etc/mysql/mysql.conf.d/mysqld.cnf
centos: vim /etc/my.cnf
/etc/init.d/mysql restart
解决windows IP连接linux mysql时出现的权限问题
允许指定IP访问 :
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.3.18' IDENTIFIED BY 'root' WITH GRANT OPTION;
不需要刷新授权表
ubuntu:vim /etc/mysql/mysql.conf.d/mysqld.cnf
centos: vim /etc/my.cnf
/etc/init.d/mysql restart