MySQL 之用户管理

MySQL 大约 493 字

创建用户

CREATE USER 'newuser'@'%' IDENTIFIED BY 'zblogpwd';

GRANT SELECT, INSERT, UPDATE ON testdb.* TO 'z-blog'@'%';

SHOW GRANTS FOR 'newuser'@'%';

WITH GRANT OPTION

GRANT privileges ON databasename.tablename TO 'newuser'@'host' WITH GRANT OPTION;

REVOKE privilege ON databasename.tablename FROM 'newuser'@'host';

rename user 'newuser'@'%' to 'renameuser'@'%';

DROP USER 'renameuser'@'host';

阅读 841 · 发布于 2019-04-04

———— END ————

扫描下方二维码关注公众号和小程序↓↓↓

昵称：

随便看看换一批