让 MySQL 用户创建数据库,但只允许访问他们自己的数据库

2021-11-20 00:00:00 mysql

我想要多个一个 MySQL 用户能够发出像

I want to have multiple a MySQL users to be able to issue commands like

CREATE DATABASE dbTest;

但我也希望这些用户中的每一个都只能查看和访问他们自己的数据库.

But I also want each of these users to be able to see and access only their own databases.

我所能找到的只是如何由 DBA 创建数据库并将此数据库的权限授予特定用户:

All I could find was how to either create the databases by a DBA and grant the privileges on this database to the specific user:

GRANT ALL PRIVILEGES ON dbTest.* TO 'user';

或将所有数据库的权限授予用户:

or grant privileges on all databases to a user:

GRANT ALL PRIVILEGES ON *.* TO 'user';

但两者都不是我想要的,因为它需要扩展和安全.

But neither is what I want, because it needs to scale and be secure.

推荐答案

您可以使用

GRANT ALL PRIVILEGES ON `testuser\_%` .  * TO 'testuser'@'%';

授予用户 testuser 对名称以 testuser_ 开头的所有数据库的权限.

to grant the user testuser privileges on all databases with names beginning with testuser_.

这允许 testuser 创建仅限于以 testuser_ 开头的名称的数据库

This allows the testuser to create databases limited to names starting with testuser_

相关文章