MySQL设置密码并赋予外部连接权限

最新推荐文章于 2025-02-27 21:50:09 发布

Still and silent.

最新推荐文章于 2025-02-27 21:50:09 发布

阅读量158

点赞数 3

CC 4.0 BY-SA版权

文章标签： mysql

本文链接：https://blog.youkuaiyun.com/Still_and_silent/article/details/131521882


[root@6721 mysql5.7]#mysql -uroot -p
Enter password:
mysql: [Warning] Using a password on the command line interface can be insecure.
......
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
mysql> set password=password("root");
mysql> grant all privileges on *.* to root@'%' identified by 'root' with grant option;
mysql> flush privileges;
mysql> exit;