database shell

This command allows users to enter the database shell.

Syntax:dbShell

Note
Use the following credentials for logging in to the database shell:
Username: admin
Password: admin123
Use the following credentials for logging in to the Public Cloud database shell:
Username: admin or root
Password: <Last 6 digits of the instance ID
To know the Manager server instance ID, run the status command in the Manager shell.

Note
For security reasons, Trellix recommends that you change the database password.

Important
The database password can be a combination of alphabets [both uppercase (A-Z) and lowercase (a-z)], numbers [0-9] and/or, special characters like "~ ` ! @ # $ % - * _ + [ ] : ; , ( ) ? { }".

Note
You should enter the specific database to perform operations in it. To access a particular database execute use <database_name>. The database options available in the MariaDB are information_schema, lf, mysql, performance_schema, and test.

Sample Output:

IPSManager> dbShell

Please enter DB User: admin

[sudo] password for admin:

Enter password:

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 13179

Server version: 10.3.13-MariaDB-log MariaDB Server

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> use lf

Database changed

MariaDB [lf]>

Note
You can perform operations in the database shell using MariaDB commands. For more information, see MariaDB documentation.