摘要: 创建用户并设置密码 CREATE USER 'username'@'localhost' IDENTIFIED BY 'password'; 赋予用户访问特定数据库的权限 GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost 阅读全文
posted @ 2024-04-28 11:26 白玉神驹 阅读(3) 评论(0) 推荐(0) 编辑
摘要: 给用户赋予表的权限 -- 赋予 SELECT 权限 GRANT SELECT ON TABLE table_name TO username; -- 赋予 INSERT, UPDATE, DELETE 权限 GRANT INSERT, UPDATE, DELETE ON TABLE table_na 阅读全文
posted @ 2024-04-28 11:17 白玉神驹 阅读(8) 评论(0) 推荐(0) 编辑