MySQL中怎么创建新用户并赋予所有权限，相信很多没有经验的人对此束手无策，为此本文总结了问题出现的原因和解决方法，通过这篇文章希望你能解决这个问题。
创新互联建站主要从事网站建设、成都网站建设、网页设计、企业做网站、公司建网站等业务。立足成都服务新华,十载网站建设经验,价格优惠、服务专业,欢迎来电咨询建站服务:028-86922220
创建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中怎么创建新用户并赋予所有权限的方法了吗？如果还想学到更多技能或想了解更多相关内容，欢迎关注创新互联行业资讯频道，感谢各位的阅读！