Managing databases in BrainyCP

BrainyCP control panel allows you to create and manage databases, as well as configure users with appropriate access rights.

Quick start

1. To manage databases, log in to BrainyCP control panel on your VPS.
2. Перейдите в раздел DB → MySQL Database.

BrainyCP control panel sections

Create a database

1. Create a new database user by specifying the required parameters:
   • Login.
   • Password.
2. Create a new database by specifying its name.
3. Click on Add User and Add Database respectively.

Creating a database and user in BrainyCP

After successfully creating the database and user, assign the necessary rights:

• Select the user.
• Select the database.
• Set all permissions.
• Save the selected parameters.

Configuring database user rights in BrainyCP

Manage a database

1. To manage the database, go to the PHPMyAdmin panel (DB → PHPMyAdmin).
2. Log in using the user data specified during the creation.

Logging into PHPMyAdmin from BrainyCP

Import a database

1. In PHPMyAdmin, select the database to import and go to the Import tab.
2. Choose the database file (e.g., bd.sql) or an archived file with the extensions: bd.sql.gzip, bd.sql.bzip2 или bd.sql.zip.
3. Specify the parameters:
   • Partial import.
   • File encoding.
   • Format.
   • Check foreign keys.
4. Start the import process.

Importing a Database in PHPMyAdmin