- 查看mysql版本号 mysql --version
- mysql -u root -p
3.use mysql
修改连接权限:
update user set host=’%’ where user =‘root’;
更改加密方式:
update user set plugin=‘mysql_native_password’ where user =‘root’;
授权远程连接:
grant all on . to ‘root’@’%’;
执行刷新权限:
flush privileges;
Linux 授权远程权限
最新推荐文章于 2024-06-17 21:27:39 发布