mysql如何創建(jian)數(shu)據庫并授(shou)權

行業動(dòng)态 公(gōng)司新(xin)聞 案例分(fēn)享 技(ji)術(shù)百(bai)科(ke)

mysql如何創建(jian)數(shu)據庫并授(shou)權

來源:奇站網絡 浏覽量:1,696 髮(fa)布日(ri)期: 2017-12-06

創建(jian)數(shu)據庫
  1. CREATE DATABASE testDB;
創建(jian)用(yong)戶(hu)
  1. create user test IDENTIFIED by 123456;
授(shou)權
  1. grant all privileges on testDB.* to test;
  2. flush privileges;
其他(tā)授(shou)權命令

查看授(shou)權

  1. show grants for test;

收回授(shou)權

  1. revoke select on testDb.* from test;
标簽:

廈們(men)奇站網絡科(ke)技(ji)有(yǒu)限(xian)公(gōng)司

電(dian)話(hua):13313868605

QQ:3413772931

地阯(zhi):廈們(men)集(ji)美區(qu)軟件園三期


                    掃一(yi)掃加(jia)我(wo)咨詢