Create MySQL database with user access in Plesk control panel

This tutorial is a part of the Plesk control panel section where we discuss server management with Plesk.

We will discuss how to add a database with Plesk on Linux server which is always My SQL.

My SQL is popular relational database management system developed ByMySQLlab. Just for your information, My SQL is an application used to Linux as well as Windows operating System, and it is a freeware application.

In a few steps I will describe how in Plesk control panel you can add database with user access.

Start with logging into the Plesk control panel. Usually it is your domain or IP address with :8443 suffix like https://yourdomain.com:8443.

Once you are inside, go to domains and click on the domain under which you want to create the database.

Create MySQL database with user access in Plesk control panel

The next step will be to choose the database module under the Plesk service section.

Create MySQL database with user access in Plesk control panel

Inside the Add New Database menu put Database name, then choose MySQL type, and choose a location of the database. In this case we are talking about creating the MySQL database on the same sever.

Create MySQL database with user access in Plesk control panel

Click OK and you will see a new icon for Add New Database User.

Create MySQL database with user access in Plesk control panel

Click on the Icon and enter database username and password.

Create MySQL database with user access in Plesk control panel

Once the credentials are entered, click OK and you will see the new MySQL database user added in Plesk.

Create MySQL database with user access in Plesk control panel

Now you have your Plesk database setup and you can start using the database with your applications.

In this case what we have created is:

Host: localhost – this is your database server, which in this case is local
Database: mydatabase
User: dbuser
Pass: *****

These four are enough as information for almost any application requiring database.

For example if you want to setup WordPress blog you will have to enter these settings into the ‘config-sample.php’:

As you can see the PHP script is using exactly the above settings and noting more for connecting to the MySQL database.

I hope you this tutorial were helpful for you. You can see more Plesk tutorials in our server management section.

Tags

Filed Under: Plesk Control Panel

Anthony Gee About the Author: Anthony G. is an IT specialist with more than 9 years of solid working experience in the Web Hosting industry. Currently works as server support administrator, involved in consultative discussions about Web Hosting and server administration. One of the first writers in the Onlinehowto.net website, now writing for Free Tutorials community - he is publishing tutorials and articles for the wide public, as well as specific technical solutions.

Comments (5)

  1. Ashwini says:

    I search everywhere how to create user name but cant find. I think web user you talk. I create it but still script show cant able to connect database. I use windows plesk control panel in my other site. I try again.

  2. Vince says:

    How about user privilege access? How can I do that in Plesk?

  3. I guess you have to control that using phpmyadmin. But of course, you will have to go through System -> Databases -> MySql. You will have to be an admin in Plesk.

  4. VPS says:

    This was very helpful. Worked for me the first time. Thanks!

  5. Dan says:

    It’s helpful, but how can I access my database? I’ve created it, but now I want to manage it with phpmyadmin. How can I do that?

Leave a Reply