Skip to content
Host4u Limited

Databases in Plesk: create, phpMyAdmin, export and repair

Support Portal  »  Knowledgebase  »  Viewing Article
There was a problem loading the comments.
  Print

Plesk manages MySQL (MariaDB) databases for your websites.

Create a database

  1. Open your domain's Dashboard and click Databases, then Add Database.
  2. Enter the Database name. Plesk adds a prefix to it.
  3. Leave Database server as it is, and choose the Related site if you want to link it.
  4. Under Users, keep Create a database user ticked, enter a user name and a password (Generate makes one).
  5. Choose the Access control: Allow local connections only is the safest if your website is on this server. Remote access is only for tools on another machine.
  6. Click Create Database and note the name, user and password for your website's configuration.

Open phpMyAdmin

On the Databases page, click the phpMyAdmin button next to the database. There you can browse, import and export. See phpMyAdmin: opening, exporting, importing and repairing.

Export a copy (dump)

On the Databases page, click Export Dump next to the database. Your browser downloads an archive. Do this before you delete a database or make big changes.

Repair a database

Click Check and Repair next to the database. Plesk checks the tables and repairs any it finds broken, and tells you if there were no errors.

Delete a database

Export a dump first, then click Remove Database next to it. This cannot be undone.

Users

The User Management tab on the same page lists the database users and lets you change a user's password.


Share via
Did you find this article useful?  

Related Articles


Self-Hosted Help Desk Software by SupportPal