You can create an account for connection to a TencentDB for MariaDB instance. This document describes how to create an account in the TencentDB for MariaDB Console and modify account permissions.
The account cannot be created or modified through command lines
insert into mysql.user,
Creating an Account
- Log in to the MariaDB Console and click the instance ID or Manage in the "Operation" column to enter the instance management page.
- Select the Manage Account tab and click Create.
- In the pop-up dialog box, enter the account name, primary server, password, and remarks, and click Confirm and Go Next.
- **Primary Server **: it is similar to a host, and supports IP, IP range, and %. % means all the IP addresses within a range. For example, to support all IPs from 10.10.10.1 to 10.10.10.254, enter
- Create as read-only account: if you check this option, the account can only use read-only requests (select).
You need to set permissions separately for different primary server IPs under the same account. You can use the Clone Account feature in account management to quickly clone similar accounts and set their permissions.
- In the pop-up dialog box, set the database permissions and click Save Settings, or click Set Later.
- On the account management page, click Modify Permissions in the "Operation" column.
- In the pop-up dialog box, grant permissions based on your needs and click Save Settings.
The permissions of MariaDB are defined at the object level, including 19 permissions of database. You can set permissions for objects such as tables, views, functions and triggers.
You need to create a database before setting the object-level permissions.