Step 1: Add a Database
Database audit supports databases built on ECS, BMS, and RDS on Huawei Cloud. After purchasing a database audit instance, you need to add the database to be audited to the instance.
For details about the types and versions of databases that can be audited by database audit, see Supported Database Types and Versions.
Prerequisites
You have purchased a database audit instance and the Status is Running.
Adding a Database
- Log in to the management console.
- Select a region, click , and choose . The Dashboard page is displayed.
- In the navigation tree on the left, choose Databases.
- In the Instance drop-down list, select the instance whose database is to be added.
- Click Add Database.
- In the dialog box displayed, set the database information, as shown in Figure 1.
Table 1 Parameters Parameter
Description
Example Value
Name
Custom name of the database to be added
test1
IP Address
IP address of the database to be added.
It must be an intranet IPv4 (for example, 192.168.1.1) or intranet IPv6 (for example, fe80:0000:0000:0000:0000:0000:0000:0000) address.
192.168.1.1
Type
Supported database type. The options are as follows:- MYSQL
- ORACLE
- POSTGRESQL
- SQLSERVER
- DWS
- GaussDB(for MYSQL)
- GaussDB(for openGauss)
- DAMENG
- KINGBASE
- MongoDB
NOTE:If ORACLE is selected, to make the audit settings take effect, restart the applications to be audited and log in to the database again.
MYSQL
Port
Port number of the database to be added
3306
Version
Supported database versions
- When Type is set to MYSQL, the following versions are available:
- 5.0, 5.1, 5.5, 5.6, 5.7
- 8.0 (8.0.11 and earlier)
- 8.0.23
- 8.0.25
- If RDS database is selected, a list of database instances will be displayed for you to choose from. You do not need to install the agent.
- When Type is set to ORACLE, the following versions are available:
- 11g
- 12c
- 19c
- When Type is set to POSTGRESQL, the following versions are available:
7.4 or later
- When Type is set to SQLSERVER, the following versions are available:
- 2008
- 2012
- 2014
- 2016
- 2017
- When Type is set to DWS, the following versions are available:
- 1.5
- When Type is set to GaussDB(for MySQL), the following versions are available:
- When Database Type is set to Self-built database, you can select the MySQL 8.0 version.
- If RDS database is selected, a list of database instances will be displayed for you to choose from. You do not need to install the agent.
- When Type is set to GaussDB(for openGauss), the following version is available:
- 1.4 Enterprise Edition
- When Type is set to DAMENG, the following version is available:
- DM8
- When Type is set to KINGBASE, the following version is available:
- V8
5.0
Instance
Instance name of the database to be audited
NOTE:- If you do not configure the Instance field, database audit will audit all instances in the database.
- If you enter an instance name, database audit will audit the entered instance. Enter a maximum of five instance names and use semicolons (;) to separate instance names.
-
Character Set
Encoding format of the database character set. The options are as follows:
- UTF-8
- GBK
UTF-8
OS
OS of the added database. The options are as follows:- LINUX64
- WINDOWS64
LINUX64
Database Type
Type of the database to be added. Its value can be RDS database or Self-built database.
RDS database
- Click OK. Then a database in the Disabled state has been added to the database list. See Figure 2.
- After adding the database, confirm that the database information is correct. If the database information is incorrect, locate the target database and click Delete in the Operation column, and add the database again.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.