創建(jian)數(shu)據庫
CREATE DATABASE testDB;
創建(jian)用(yong)戶(hu)
create user test IDENTIFIED by 123456;
授(shou)權
grant all privileges on testDB.* to test;flush privileges;
其他(tā)授(shou)權命令
查看授(shou)權
show grants for test;
收回授(shou)權
revoke select on testDb.* from test;
- 版權所有(yǒu):奇站網絡 轉載請(qing)注明出處
- 廈們(men)奇站網絡科(ke)技(ji)有(yǒu)限(xian)公(gōng)司,專(zhuan)業提供網站建(jian)設(shè),響應式(shi)網站建(jian)設(shè),小(xiǎo)程(cheng)序開髮(fa),係(xi)統定製(zhi)開髮(fa)。
- 軟件開髮(fa)咨詢熱線(xiàn):吳小(xiǎo)姐 13313868605
