美文网首页
mysql8.0.15修改密码,开启远程连接

mysql8.0.15修改密码,开启远程连接

作者: yundd | 来源:发表于2019-07-31 10:04 被阅读0次

1.修改密码

ALTER user 'root'@'localhost' IDENTIFIED BY 'password' 

2.开启远程连接

mysql> use mysql;
Database changed
mysql> grant all privileges  on *.* to root@'%' identified by "password";
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

相关文章

网友评论

      本文标题:mysql8.0.15修改密码,开启远程连接

      本文链接:https://www.haomeiwen.com/subject/okxzrctx.html