mysql数据库如何权限设置密码

-- 设置新密码
ALTER USER 'username'@'localhost' IDENTIFIED BY 'new_password';

-- 或者使用SET PASSWORD命令
SET PASSWORD FOR 'username'@'localhost' = PASSWORD('new_password');

-- 授予全局权限
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;

-- 授予数据库权限
GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';

-- 授予表权限
GRANT SELECT, INSERT, UPDATE ON database_name.table_name TO 'username'@'localhost';

-- 刷新权限
FLUSH PRIVILEGES;

-- 撤销全局权限
REVOKE ALL PRIVILEGES ON *.* FROM 'username'@'localhost';

-- 撤销数据库权限
REVOKE ALL PRIVILEGES ON database_name.* FROM 'username'@'localhost';

-- 撤销表权限
REVOKE SELECT, INSERT, UPDATE ON database_name.table_name FROM 'username'@'localhost';

-- 刷新权限
FLUSH PRIVILEGES;

-- 查看用户权限
SHOW GRANTS FOR 'username'@'localhost';