文章转载于这里.
- 打开cmd窗口,并进入到MySQL安装路径的bin目录下:
- 运行命令:(u后面跟的是用户名;p后面跟的是密码)
mysql -uroot -proot
- 进入数据库
use mysql
- 使用命令设置远程连接
// mysql5.7
GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
//mysql8
//修改密码认证方式为mysql_native_password
CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123123';
GRANT ALL ON *.* TO 'root'@'%';
- 更新刚修改的权限,使其生效
flush privileges;
- 查看修改结果
select host,user from user;