Database

INFO

For servers running MySQL | MariaDB | PostgreSQL FlashPanel provides a number of advanced features that allow you to manage your database and database users as easily as , import/export, synchronization, ...

Install Database

When creating a server

Create a server with the following database:

1. Go to create server page and follow the instructions in [Server Connection](.. /connect/connect-server.md)
2. In the Choose pre-installed apps section, select a database (MySQL | MariaDB)

FlashPanel will then automatically install the server with the selected database and create a database user flashvps, the user password being randomly generated. The database username and password will be sent to your mail when the server is created successfully.

In the applications tab

If you later decide that you need to install a database on your server, you can install it through the server's Applications tab. Once installed, you will be able to manage your database through FlashPanel.

Create database

You can create new databases through the server's Databases tab under FlashPanel. At a minimum, you must provide the name of your new database. Users can access the database.

1. At the Database tab > Select Create Database
2. Enter the name of the database you want to create and select the users who can access the database (Optional).
3. Select Save

Create a database user

You can create additional database users through the Database tab of the FlashPanel control panel. To do so, you need to provide at least a username and password.

1. At the Database tab
2. Select Create database user and enter username, password, access scope, database you want to access
3. Select Save

Import database

Method 1: From the Database tab

1. Select the Database you want to import > Click the Import Database button

   

2. Upload the database dump file you want to import, with the supported extension .sql or .sql.gz

3. After downloading is complete, the system will automatically send the database import command

Method 2: From File Manager

1. Open File Manager and navigate to the database dump file you want to import

2. Right-click and select Import Database

   

3. Select the Database you want to import > Click the Submit button

   

Export database

1. Click on the Export Database button
2. Click the Create Backup button
3. Wait for the backup process to take place, after completion the download button will appear

Synchronize the database

In FlashPanel, the database sync feature allows users to easily synchronize the names of databases and database usernames on the server. This way, the administrator can ensure that all database information on the server is synchronized so that it can be operated on the panel.

Access MySQL remotely

See more here

phpMyAdmin

Unlike the panels or scripts you used before, phpMyAdmin in FlashPanel is a standalone website.

See more here