MySQL远程访问授权

最新推荐文章于 2023-07-09 23:27:13 发布

Yanggle Yang

最新推荐文章于 2023-07-09 23:27:13 发布

阅读量137

点赞数

分类专栏： MySQL

本文链接：https://blog.youkuaiyun.com/yanggleyang/article/details/104448289

版权

MySQL 专栏收录该内容

1 篇文章

订阅专栏

文章目录

c:\mysql\bin>mysql -h localhost -u root

mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.1' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES
mysql>EXIT