mysql权限相关

创建用户并设置密码

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

赋予用户访问特定数据库的权限

GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

赋予用户对特定表的权限

GRANT SELECT, INSERT, UPDATE ON database_name.table_name TO 'username'@'localhost';

限制用户登录的IP地址

CREATE USER 'username'@'192.168.1.%' IDENTIFIED BY 'password';

撤销用户的权限

REVOKE SELECT ON database_name.table_name FROM 'username'@'localhost';

查看用户的权限

SHOW GRANTS FOR 'username'@'localhost';

刷新权限(更改后刷新才会生效)

FLUSH PRIVILEGES;

删除用户

DROP USER 'username'@'localhost';