`
dch1287
  • 浏览: 119851 次
  • 性别: Icon_minigender_1
  • 来自: 魔都
社区版块
存档分类
最新评论

mysql 创建用户

    博客分类:
  • DB
阅读更多
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;


分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics