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中怎么創建新用戶并賦予所有權限的方法了嗎？如果還想學到更多技能或想了解更多相關內容，歡迎關注億速云行業資訊頻道，感謝各位的閱讀！