CREATE USER 'euht_vehicle'@'%' IDENTIFIED BY 'euht@2022';
GRANT SElECT ON *.* TO 'euht_vehicle'@'%' IDENTIFIED BY "euht@2022";
flush privileges;
限定只能看哪个数据库
GRANT SElECT ON test.* TO 'euht_vehicle'@'%' IDENTIFIED BY "euht@2022";
这篇博客介绍了如何在MySQL中创建用户'euht_vehicle',并为其分配全局和特定数据库的SELECT权限。通过GRANT语句,用户可以在任意位置访问数据库,并且被限制只能查看'test'数据库的内容。FLUSH PRIVILEGES命令确保了权限的立即生效。
CREATE USER 'euht_vehicle'@'%' IDENTIFIED BY 'euht@2022';
GRANT SElECT ON *.* TO 'euht_vehicle'@'%' IDENTIFIED BY "euht@2022";
flush privileges;
限定只能看哪个数据库
GRANT SElECT ON test.* TO 'euht_vehicle'@'%' IDENTIFIED BY "euht@2022";
5534
1625
406
2981

被折叠的 条评论
为什么被折叠?