mysql创建用户，并授权

CREATE USER ‘username‘@‘host‘ IDENTIFIED BY ‘password‘;

CREATE USER ‘zsg‘@‘%‘ IDENTIFIED BY ‘123456‘;

GRANT privileges ON databasename.tablename TO ‘username‘@‘host‘

CREATE USER ‘dfjrCase‘@‘%‘ IDENTIFIED BY ‘Dfjr1688‘;

GRANT ALL PRIVILEGES ON dfjr_case.* TO ‘dfjrCase‘@‘%‘ IDENTIFIED BY ‘Dfjr1688‘;

flush privileges;

mysql创建用户，并授权

标签：mysql   cas   create   database   blank   tar   use   user   lan