How to create a Mysql or MSSQL DB in Plesk Panel

How to create a Mysql or MSSQL DB in Plesk Panel

 Steps to create a DB and a DB user in Plesk

        Step 1: Login To the Plesk control panel.

        Step 2: Go to the DB.

          

          Step 3: Next page click Add DB

          

           Step 4: Assign a name to your DB within the DB  name field and select the DB server Mysql or MSSQL from the drop-down menu.

             
 

             Step 5: A DB must have at least one user account associated with it. Otherwise, it will be impossible to access the DB.

                          You can create a DB user while creating a DB by selecting the create a DB user checkbox. Alternatively, you

                          can select a user later, for example,  if you want to use one of the existing user accounts.

            Step 6: Select Create a DB user. if you want to create a new user for this DB and enter a username and password for it. Otherwise, deselect the option.

            Step 7: Assign a username to your DB within the DB username field.

            Step 7:Assign a password to your DB user within the New Password field.

            Step 8: To use the DB user for accessing any of your DB, select User has access to all DB within the selected subscription.

            Step 9: Click Ok
 

           
 

           Step 10 : Now your DB will now be set up and ready to use.



    • 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 ...

    • Create or delete a subdomain with Plesk

      Steps to create or delete a sub-domain Description: You have a website your-product.com dedicated to promoting and selling your product. For publishing information related to customer service and online order tracking, you can organize the subdomain ...

    • 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 ...

    • Make a MySQL DB copy in Plesk

      Make a MySQL DB copy in Plesk Steps to access DB using root Step 1: Visit the URL http://<your_domain>:8880 or https://<your_domain>:8443 (For SSL) and login. Step 2: Click on DB then select DB. Step 3: Click on copy link on a particular DB. Step 4: ...

    • Reset Plesk Demo Control Panel Login

      In order to reset the login details periodically for the demo control panel, the bset option would be to restore the demo domains and client logins through the Plesk Backup/Restore Command Line Utility. For Linux Server Login to shell as root user. # ...