Creating a MySQL Database in Plesk

Creating a MySQL Database in Plesk

Creating a MySQL Database in Plesk

        Visit the URL http://<your_domain>:8880  or https://<your_domain>:8443 (For SSL)

        Step 1: Log in to the Plesk Control Panel to create a MySQL Database and click on Website and Domain then select Database

Click on add Database link.



Step 2. Following are the input required fields as given below:
    A. Assign a new database name in Database name.
    B. Select related site name from the dropdown listed.
    C. Check on create a new database user for that database.
    D. Enter the database user name.
    E. The passwords fields you can fill by generating a password or can input manually (maintain security policies).
    F. Click on OK button to create the database.


Step 3: you can view the newly created database in database section.

1. Can manage the database by clicking phpMyAdmin link.

To access MySQL Database using phpMyAdmin, Please follow the below given KB link:
     https://kb.diadem.in/index.php?View=entry&EntryID=434



    • Related Articles

    • Backup and restore MySQL database with Plesk

      Backup and restore MySQL database with Plesk Description: In Plesk, database dumps are created in the SQL format and saved as ZIP archives. If you need to create a dump in another format or to set custom settings for a dump, use the native ...
    • Plesk database missing in subscription

      Check and Move database between different subscription Issue: Database is not showing under the original Subscription from Plesk Panel Observation: With the following command it is found under which subscription the database is currently exist. ( ...
    • How to check Database Process List in Plesk Linux

      How to check the Database Process List in Plesk Linux We will follow the below steps to check the database process list from the Plesk Panel Step 1: Log in to the Plesk Panel > Tools & Settings > Database Process List Step 2: We can find the list of ...
    • Creating ODBC DSN through PLESK

      Creating ODBC DSN through PLESK Description: A Data Source Name (DSN) is the ODBC logical name for the drive and other information the database needs to access data. The name is used by Internet Information Services (IIS) for a connection to an ODBC ...
    • Important Plesk CLI Commands

      Important Plesk Linux CLI Commands If Plesk throws an error, these logs will help. /usr/local/psa/var/log /opt/psa/admin/logs /var/log/sw-cp-server/error_log /usr/local/psa/admin/logs/panel.log /usr/local/psa/admin/logs/httpsd_access_log ...