- 连接本地MySQL数据库
mysql -u root -p
- 配置用户授权
# 查看user表信息
use mysql;
select host,user from user;
# 授权远程登录
update user set host ='%' where user ='root';
# 修改权限(当前root用户的密码123456)
grant all on *.* to 'root'@'%' identified by '123456' with grant option;
# 重新加载授权表
flush privileges;