JZTXT

MySQL用户及权限相关

发布时间 2023-03-27 10:58:21作者: 草原悍匪

1、创建用户：

CREATE USER 'test'@'%' IDENTIFIED BY 'XXXXXXX';
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER ON bdp.* TO 'test'@'%';

2、修改密码：

set password for 'mysqluser'@'ip' = password('newpassword');
例：
set password for 'root'@'localhost' = password('root');
set password for 'root'@'%' = password('root');
set password for 'root'@'192.168.128.128' = password('root');

3、回收权限：

revoke insert on zabbix.* from zabbix@localhost;

4、查看用户拥有那些权限

SHOW GRANTS FOR 'username'@'hostname';