查询用户表命令:
select User,password,Host from mysql.user;
新增权限用户设置的密码:
GRANT ALL PRIVILEGES ON *.* TO 'testuser'@'%' IDENTIFIED BY '123456';
重新加载权限数据:
flush privileges;
两种方法:
1. 改表法
//登录数据库
mysql -u root -pvmwaremysql>use mysql;
//%为所有ip都可以远程访问
mysql>update user set host = '%' where user = 'root';
//或直接添加一条语句也行
mysql>insert into user (host,user,password)values('192.168.0.51','root',password('123'));
//查看一下修改
mysql>select host, user from user;
//推送设置到内存或重启服务器也行
mysql>FLUSH PRIVILEGES
2. 授权法
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
如果是固定ip就这么写
grant all privileges on *.* to 'root'@'192.168.0.49'identified by '123' with grant option;
//推送设置到内存或重启服务器也行
mysql>FLUSH PRIVILEGES