創(chuàng)建數據庫

CREATE DATABASE testDB;

創(chuàng)建用戶

create user test IDENTIFIED by 123456;

授權

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

其他授權命令

查看授權

show grants for test;

收回授權

revoke  select on testDb.* from test;