gcloud mysql仅阅读用户
出于安全原因，我想在GCloud中拥有一个仅选择索具的MySQL用户，即仅选择读取用户。
目前，我已经创建了一个用户，并试图使用以下代码使用root帐户更改其权利：
REVOKE DROP,DELETE ON *.* FROM 'read_account'@'%';
但是0行受到影响：
Query OK, 0 rows affected (0.14 sec)
赠款使用情况相同的问题，该问题应该删除所有权利，但仍然没有仅在读取帐户中更改。
GRANT USAGE ON *.* TO 'read_account'@'%';
Query OK, 0 rows affected (0.17 sec)
Gcloud Root帐户是否允许我们修改其他帐户？还是还有另一种解决方案可以授予数据库用户的特定特权？
I'd like to have a mysql user in GCloud that has only select rigths, i.e. a read only user, for security reasons.
For the moment, I have created a user and tried to change its rights with the root account using the following code:
REVOKE DROP,DELETE ON *.* FROM 'read_account'@'%';
But 0 rows are affected:
Query OK, 0 rows affected (0.14 sec)
Same issue with the GRANT USAGE, which should have remove all the rights, but there is still no change in the read only account.
GRANT USAGE ON *.* TO 'read_account'@'%';
Query OK, 0 rows affected (0.17 sec)
Does GCloud root account allows us to modify other accounts? Or is there another solution to grant specific privileges to DB users?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
1.Drop用户'read_account'@'％';
2.创建用户'read_account'@'％'由“密码”确定；
3.将。上的选择授予'read_account'@'％';
4.Flush特权；
1.drop user 'read_account'@'%';
2.create user 'read_account'@'%' identified by 'password';
3.grant select on . to 'read_account'@'%';
4.flush privileges;