mysql中怎么创建新用户并赋予所有权限

mysql中怎么创建新用户并赋予所有权限，相信很多没有经验的人对此束手无策，为此本文总结了问题出现的原因和解决方法，通过这篇文章希望你能解决这个问题。

创建mysql的新用户并赋予所有权限

grant all privilegeson *.* to  tet6@"%" identified by '123456' WITH GRANT OPTION;

CREATE USER 'tet'@'%' IDENTIFIED BY '123456';

CREATE USER 'wj123456'@'%' IDENTIFIED BY '123456';

GRANT ALL PRIVILEGES ON * . * TO 'tet'@'%' IDENTIFIED BY '***' WITH GRANT OPTION MAX_QUERIES_PER_HOUR0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

CREATE DATABASE IF NOT EXISTS `tet` ;

grant select,insert ,delete,update,create,drop on *.* to   tet6@"%" identified by  "123456";

grant all privilegeson *.* to  jztet@"%" identified by '123456' WITH GRANT OPTION;

grant select,insert ,delete,update,create,drop on *.* to   jztet@"%" identified by  "39efbfef4a0021";

grant   all privilegeson  *.* to   jztet@"%" identified by  "39efbfef4a0021";

grant select,delete,update,create,drop on *.* to   huangjz@"%" identified by  "39efbfef4a0021";

 GRANT ALL PRIVILEGES ON *.* TO 'huangjz'@'%'IDENTIFIED BY '39efbfef4a0021' WITH GRANT OPTION;

 GRANT ALL PRIVILEGES ON *.* TO 'jztet'@'%'IDENTIFIED BY '39efbfef4a0021' WITH GRANT OPTION;

 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '123456' WITH GRANT OPTION;

看完上述内容，你们掌握mysql中怎么创建新用户并赋予所有权限的方法了吗？如果还想学到更多技能或想了解更多相关内容，欢迎关注亿速云行业资讯频道，感谢各位的阅读！

亿速云「云数据库 MySQL」免部署即开即用，比自行安装部署数据库高出1倍以上的性能，双节点冗余防止单节点故障，数据自动定期备份随时恢复。点击查看>>