Web-based aaPanel Management’s “Database” sidebar menu will be the topic of this post.

1) Add database

To successfully create a database, first input the database name, then pick the encoding type, enter the password, and configure the access rights.

DBname: the name of the new database; pick the encoding format, which is UTF-8 by default.

Password: The default password is a random password that you may change.

Permission: The local server permission is the default. Everyone or provide an IP address are the possibilities. 

Force SSL: Force the user to utilize an SSL connection, which may render the client unreachable if it lacks a certificate (the certificate can be downloaded in the SSL tag of the MySQL manager)

2) Change root password

If you are unable to add data or are being prompted for an incorrect password, you can try to change the root password to resolve the issue.

Note that the default password is random, and root is the password for the highest-privilege account.
Please proceed with care.

3) Backup Database

There are two kinds of backup: manual backup and automatic backup.
 
3.1 – Manual backup
 
3.2 – Automatic backup

4) Restore & Import

 

+ You have the option of uploading locally or restoring the backed-up files.

+ By default, the database is located in /www/backup/database.

+ All of the backup imports above make use of mysqldump.

+ The imported sql file’s format must be consistent with the standard. If you utilize the sql file exported by phpmyadmin.

+ information such as the version code may be missing, preventing the file from being successfully imported by mysqldump.

+ If you are unable to import normally, you can use phpmyadmin to import.

5) Permission Management

+ Local server: Restricts access to the current database to this server.
+ Anyone: Anyone can connect remotely to the database.
+ IP address: Only specified IP addresses are supported; only one IP address is supported.
+ If you require external network connectivity, you must still open the MySQL port in the firewall (default 3306).
+ Forcing SSL: Forcing the user to use an SSL connection, which may render the client without a certificate unreachable (the certificate can be downloaded in the SSL tag of the MySQL manager)

6) Change Database password

Change the current database account’s password.

Note: The password that is now edited is not the root password; if you need to modify the root password.