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中怎么创建新用户并赋予所有权限的方法了吗？如果还想学到更多技能或想了解更多相关内容，欢迎关注开发云行业资讯频道，感谢各位的阅读！
本篇内容介绍了“java基础模块依赖是什么”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！Maven 一个核心的特性就是依赖管理。当我们处理多模块的项目（包含成百…
免责声明：本站发布的图片视频文字，以转载和分享为主，文章观点不代表本站立场，本站不承担相关法律责任；如果涉及侵权请联系邮箱：360163164@qq.com举报，并提供相关证据，经查实将立刻删除涉嫌侵权内容。
微信扫一扫 
