向 mariadb 用户授予创建数据库权限
我知道在数据库管理中，使用 root 用户是一种不好的行为，我正在设置一个具有基本权限的自定义用户(创建数据库、删除数据库、对所有新创建的数据库的所有访问权限等).
我创建了一个用户 antoine，它应该是用于登录 mariadb 服务器 的基本用户.
I know that in database management, it's a bad behavior to use the root user and I'm setting up a custom user with base privileges (create database, drop db, all access to all newly created dbs, etc).
I've created a user antoine which should be the base user used to login to the mariadb server.
问题是，我不知道如何授予管理权限，如 create database xxx、drop database xxx 等...文档解释说授予一个特权，你运行以下命令:
Problem is, I can't figure out how to grant administration privileges like create database xxx, drop database xxx, etc... The documentation explains that to grant a privilege, you run the following command:
GRANT role ON database.table TO user@host
但是，当涉及到服务器权限时，我该怎么做呢?我试过 *.* 而不是 database.table 但它不起作用.
But, when it comes to server privileges, how can I do it ? I've tried the *.* instead of database.table but it's not working.
推荐答案
创建一个用户，然后授予该用户您希望他们拥有的权限.
Create a user and then grant that user the privileges you want them to have like this.
CREATE USER 'antoine'@'localhost' IDENTIFIED VIA mysql_native_password USING 'a-password';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON *.* TO 'antoine'@'localhost';
相关文章