白玉神驹

摘要： 创建用户并设置密码 CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; 赋予用户访问特定数据库的权限 GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost 阅读全文

摘要： 给用户赋予表的权限 -- 赋予 SELECT 权限 GRANT SELECT ON TABLE table_name TO username; -- 赋予 INSERT, UPDATE, DELETE 权限 GRANT INSERT, UPDATE, DELETE ON TABLE table_na 阅读全文