mysql 创建用户

最新推荐文章于 2024-01-05 11:37:44 发布

dch1287

最新推荐文章于 2024-01-05 11:37:44 发布

阅读量92

点赞数

分类专栏： DB 文章标签： MySQL Java

本文链接：https://blog.csdn.net/dch1287/article/details/83738368

版权

DB 专栏收录该内容

2 篇文章 0 订阅

订阅专栏


shell> mysql --user=root mysql 
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost 
      IDENTIFIED BY 'something' WITH GRANT OPTION; 
mysql> GRANT ALL PRIVILEGES ON *.* TO monty@"%" 
      IDENTIFIED BY 'something' WITH GRANT OPTION; 
mysql> GRANT RELOAD,PROCESS ON *.* TO admin@localhost; 
mysql> GRANT USAGE ON *.* TO dummy@localhost;