站长博客

创建用户：

CREATE USER 'admpub'@'localhost' IDENTIFIED BY 'password';

授权：

GRANT ALL ON admpub.* TO 'admpub'@'localhost';

只读授权：

GRANT SELECT ON *.* TO admpub@'%' IDENTIFIED BY 'test'; 

使授权生效：

FLUSH PRIVILEGES;