How Do I Create a MySQL Database? Using phpMyAdmin

Most software such as WordPress, OpenCart and PrestaShop stores its data in a MySQL / MariaDB database. Before installing it, you need to create a database and a database user.

Creating a database in Plesk

1. Log in to your Plesk panel at https://yourdomain.com:8443 or from the service page in your client area.
2. Click Databases in the left menu and press Add Database.
3. Enter the database name and choose the related website.
4. Set a database user name and a strong password, then click OK.

Connection details

On Windows hosting packages you can also create MSSQL databases alongside MySQL / MariaDB; the steps are the same, just choose MSSQL as the database type.

What can I do with phpMyAdmin?

In Plesk, open phpMyAdmin with the phpMyAdmin link next to your database on the Databases page.

• Back up: select the database and download it in SQL format from the Export tab.
• Restore: select the database and upload the .sql file from the Import tab.
• Repair tables: tick the tables and choose Repair table from the menu below.

Troubleshooting

"Error establishing a database connection"

The database name, user name or password in the configuration file is wrong. Check the details; if needed, reset the user's password in Plesk and enter it in the configuration file.