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

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

原创最新推荐文章于 2025-02-27 21:50:09 发布 · 158 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql


[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;