1.连接mysql
mysql -u root -p
2.输入密码
3.查看user表
use mysql;
4.查看用户信息表
select user,host from user;
5.root从任何主机连接到mysql服务器
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
6.从指定ip主机连接到mysql服务器,并使用root作为密码
GRANT ALL PRIVILEGES ON *.* TO 'root'@'ip地址' IDENTIFIED BY '密码' WITH GRANT OPTION;
7.刷新并重新查询数据库访问权限
注:删除用户
drop user 'user名'@'host权限',例子中user名为‘root’,权限为’localhost’