![613e93001b5a153ad8eb21fb03c1e07a.png](https://i-blog.csdnimg.cn/blog_migrate/636358e5ec83f627073f795c8ffba1f6.jpeg)
linux下创建mysql用户并赋权
1.linux 已经部署好mysql,使用root用户进入mysql
mysql -uroot -p
2.//创建用户
create user doudou identified by '123456';
3.//查看用户权限
show grants for doudou;
4.//创建数据库
create database if not exists autobuild;
5.//将autobuild数据库权限赋给douodou用户
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON `autobuild`.* TO 'doudou'@'%';
6.//移除权限
REVOKE SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON `autobuild`.* from 'doudou'@'%';
7.//离开数据库
quit();