Manage Database
Last Updated：2021-04-28
Create a database
- On the "Database Management" page of the instance, you can see the created database list and the database information.
- Click the "Create Database" button to enter the "Create Database" subpage.
- Set database name and character set, select authorized account and privilege, click “OK” button to create the database. Account type has only two privileges, namely, read-only and “read/write”, Privilege allocation is as follows:
| Read-only Account | SELECT |
| Read/Write Accounts | SELECT, LOCK TABLES, SHOW VIEW, CREATE, DROP, ALTER, UPDATE, DELETE, INDEX, INSERT, CREATE TEMPORARY TABLES, TRIGGER, ALTER ROUTINE, CREATE ROUTINE, EXECUTE |
Modify database remarks
- The database supports remarks modification, which is shown on the "Database Management" subpage.
- Move the mouse to the database line, and the Pencil marker is shown in the "Description" column. After clicking, the system shows Edit box, where you can type in new remarks information. Click "OK" for saving.
Delete a database
On the "Database Management" subpage, click the "Delete" link next to the database to be deleted, and click the "OK" button to delete the database.