創(chuàng)建數(shù)據(jù)庫(kù)

CREATE DATABASE testDB;

創(chuàng)建用戶

create user test IDENTIFIED by 123456;

授權(quán)

grant all privileges on testDB.* to test;
flush privileges;

其他授權(quán)命令

查看授權(quán)

show grants for test;

收回授權(quán)

revoke  select on testDb.* from test;