Updated on 2024-05-21 GMT+08:00
Creating a Database
Scenarios
After your GaussDB(for MySQL) instance is created, you can create databases on it.
Constraints
- This operation is not allowed when another operation is being performed on your DB instance.
- After a database is created, the database name cannot be changed.
Procedure
- Log in to the management console.
- Click in the upper left corner and select a region and a project.
- Click in the upper left corner of the page, choose .
- On the Instances page, click the instance name to go to the Basic Information page.
- In the navigation pane on the left, choose Databases. On the displayed page, click Create Database. In the displayed dialog box, enter a database name, select a character set, and authorize permissions for users. Then, click OK.
Figure 1 Creating a database
- The database name can contain 1 to 64 characters. Only letters, digits, hyphens (-), and underscores (_) are allowed. The total number of hyphens (-) cannot exceed 10.
- You can click Show to view all character sets.
- You can select one or more unauthorized users. If there are no unauthorized users, you can create one.
- If you require fine-grained permissions control, log in to the database through the DAS console.
- After the database is created, authorize or delete it on the Databases page. You can search for the desired database by character set and database name.
Creating a Database Through DAS
- Log in to the management console.
- Click in the upper left corner and select a region and a project.
- Click in the upper left corner of the page, choose .
- On the Instances page, locate the instance and click Log In in the Operation column.
- On the displayed login page, enter the username and password and click Log In.
- Choose , and enter the following command to create a database:
create database Database name;
Parent topic: Database Management
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot