mysql 添加授权

GRANT ALL PRIVILEGES ON *.* TO 'global_user'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

GRANT ALL PRIVILEGES ON mydatabase.* TO 'db_user'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

GRANT SELECT, INSERT ON mydatabase.mytable TO 'table_user'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

GRANT SELECT (column1, column2) ON mydatabase.mytable TO 'column_user'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

-- 创建用户
CREATE USER 'new_user'@'localhost' IDENTIFIED BY 'password';

-- 授权
GRANT SELECT, INSERT ON mydatabase.mytable TO 'new_user'@'localhost';

-- 刷新权限
FLUSH PRIVILEGES;

-- 使用 root 用户执行授权命令
GRANT ALL PRIVILEGES ON *.* TO 'new_user'@'localhost' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;