Skip to content

Database

Need to install MySQL in the App Store of the main aaPanel before it can be used normally.

Need to install phpMyAdmin in the App Store of the main aaPanel before it can be used phpMyAdmin normally.

Database overview

alt text

FunctionDescribe
Add DatabaseAdd a MySQL database
Database NameDisplay the current database name
UsernameDisplay the user name of the current database
PasswordView, copy the password of the current database
BackupDisplays the number of backups of the current database. Click to Backup, Restore, Download, Delete backup files
PermissionsDisplay and set user login permissions for the current database
RemarksDisplay and set the remark information of the current database
ImportUpload the backup database file
phpMyAdminUse phpMyAdmin to manage databases
Modify the user password of the current database
DeleteDelete the database. Once the database is deleted, it cannot be restored. Please back up first before proceeding.

Add Database

alt text

FunctionExampleDescribe
Database Namekern_EzeMAyEnter database name
utf8mb4_danish_ciutf8mb4_danish_ciSelect the character of the database
Usernamekern_EzeMAyEnter database user name
Passwordbf2171513ffeeEnter the password of the database user
PermissionsLocalLogin permissions: Specified IP, Everyone, Local
RemarksDatabase remarks

Backup

alt text

  • Create backup copy : Click to create a database backup file

  • Upload : Upload database backup file

  • Database Name : Display the database storage path of the backup file

  • Size : Display the backup file size

  • Backup Time : Display the creation time of the backup file

  • Restore : Click to restore the database. It is recommended to restore the database after backup to avoid loss caused by data overwriting.

  • Download : Click to download the database backup file

  • Delete : Delete database backup files

Import

Upload database backup file for recovery

alt text

Permissions

alt text

  • Specified IP : Only the specified IP can be logged in using the database user and password.

  • Everyone : Allow all IPs to log in using the database user and password

  • Local : Only local login is allowed, that is: 127.0.0.1, localhost

Change Password

View and modify the user password of the current database

alt text

phpMyAdmin

Need to install phpMyAdmin in the App Store of the main aaPanel before it can be used phpMyAdmin normally.

Use phpMyAdmin to manage databases

alt text