输入banner图图片脚本导航/分类

mysql远程授权

切换到mysql的mysql数据库,找到user表;

cmd:mysql -u root -p

cmd:use mysql;

cmd:select host,user,password from user;

更新user表信息:

cmd:update user set host = ‘%‘ where user = ‘root‘;

为root用户授权密码为root:

cmd:grant all privileges on *.* to root@‘%‘ identified by ‘root‘;

刷新权限:

cmd:flush privileges;

 

mysql远程授权

标签:授权   密码   grant   用户   use   sql   where   roo   sel