mysql创建用户，分配数据库权限

假设数据库名称叫test
下面创建test用户并分配test数据库的所有权限
1，创建用户和密码

CREATE USER 'test'@'%' IDENTIFIED BY '123456';

2，将test用户绑定到test数据库上

GRANT ALL PRIVILEGES ON test.* TO 'test'@'%' IDENTIFIED BY '123456';

3，赋予权限

-- 赋予所有权限 all表示拥有数据库所有权限，还有SELECT，INSERT，UPDATE,delete,drop,ALTER,create等等。
GRANT ALL ON test.* TO 'test'@'%' IDENTIFIED BY '123456';
-- 赋予增删改查权限
-- GRANT SELECT,DELETE,UPDATE,CREATE,DROP ON test.* TO 'test'@'%' IDENTIFIED BY '123456';

4，刷新权限

FLUSH  PRIVILEGES;

下面是删除权限，和修改密码
1，删除权限

revoke all privileges,grant option from 'test'@'%';

2，刷新权限

flush  privileges;

修改密码

set password for 'test'@'%' = password('654321');

参考：https://blog.csdn.net/qq_43050077/article/details/119739244

https://blog.csdn.net/blood_Z/article/details/124964642?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522168605092816800180694572%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=168605092816800180694572&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2_allfirst_rank_ecpm_v1~rank_v31_ecpm-2-124964642-null-null.142^v88insert_down38v5,239^v2insert_chatgpt&utm_term=mysql%E5%88%9B%E5%BB%BA%E7%94%A8%E6%88%B7%E5%B9%B6%E6%8E%88%E6%9D%83all&spm=1018.2226.3001.4187