访问某个库出现访问拒绝 ``` mysql> use test; ERROR 1044 (42000): Access denied for user 'test123'@'%' to database 'test' ``` 查看用户授权信息 ``` SHOW GRANTS FOR 'test123'@'%'; ``` 查看创建用户信息 ``` show create user 'test123'@'%'\G ``` 给用户授权增删改查某个库 ``` GRANT SELECT, INSERT, UPDATE, DELETE ON `test`.* TO 'test123'@'%' ``` 给用户授权某个库所有权限 ``` GRANT ALL PRIVILEGES ON `test`.* TO 'test123'@'%' ``` 刷新变更 ``` flush privileges; ```