mysql中怎么創(chuàng)建新用戶并賦予所有權(quán)限

mysql中怎么創(chuàng)建新用戶并賦予所有權(quán)限，相信很多沒有經(jīng)驗(yàn)的人對(duì)此束手無策，為此本文總結(jié)了問題出現(xiàn)的原因和解決方法，通過這篇文章希望你能解決這個(gè)問題。

創(chuàng)建mysql的新用戶并賦予所有權(quán)限

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;

看完上述內(nèi)容，你們掌握mysql中怎么創(chuàng)建新用戶并賦予所有權(quán)限的方法了嗎？如果還想學(xué)到更多技能或想了解更多相關(guān)內(nèi)容，歡迎關(guān)注億速云行業(yè)資訊頻道，感謝各位的閱讀！