Learn how to create a database in SolidCP. Our MySQL Support team is here to help you with your questions and concerns.

How to create a database in SolidCP

SolidCP is a popular web hosting control panel. It supports multiple database management systems like MySQL, Microsoft SQL Server, and PostgreSQL. Let’s take a look at how to create a database in SolidCP:  

1. First, we have to log in to SolidCP at this link.
2. Then, head to the Databases section and click the MySQL database version we want to create.
3. Now, we will see a list of MySQL databases added previously. We can click the Create Database button to create a new MYSQL database.
4. At this point, we have to enter a name for the new database and click Save.
5. Once we see the new database in the database list, it is time to create a database user by clicking the Create User button.
6. Then, head to the SQL Properties page and set up the database username, and password, as well as the default database for the user we created.

How to import or restore a MySQL database to the server

1. Once we create a MySQL database in the SolidCP control panel, a new user login for it we have to log in to phpMyAdmin.

   We have to enter the user details we created earlier and choose the correct MySQL server hostname.
2. After that, we have to choose the right database from the dropdown list.
3. Next, click Import.
4. Then, locate the MySQL dump backup file under the File To Import field.
5. At this point, we have to use the default values in the rest of the form and click Go.

After the above steps, the database backup will be imported into the database on our server.

[Need assistance with a different issue? Our team is available 24/7.]

Conclusion

To sum up, our Support Techs demonstrated how to create a database in SolidCP.