1. 修改系统表
$mysql -u root -p root
mysql>use mysql; //使用MySQL数据库
mysql>select host, user from user; //查看修改前的结果
mysql>update user set host = '%' where user = 'root'; //修改表内容
mysql>select host, user from user; //查看修改后的结果
mysql>FLUSH PRIVILEGES; //使修改立即生效
2. 给用户授权
允许用户root使用密码root从任何主机连接mysql服务器:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;
允许用户root使用密码root从主机192.168.1.77连接mysql服务器:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.77' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;
允许用户root使用密码root从主机192.168.1.77连接mysql服务器的iep数据库:
GRANT ALL PRIVILEGES ON iep.* TO 'root'@'192.168.1.77' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;