Create MySQL database with user access in Plesk control panel
Anthony Gee | Aug 01, 2009 | Comments 5
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.
The next step will be to choose the database module under the Plesk service section.
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.
Click OK and you will see a new icon for Add New Database User.
Click on the Icon and enter database username and password.
Once the credentials are entered, click OK and you will see the new MySQL database user added in Plesk.
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’:
1 2 3 4 5 6 |
<?php define('DB_NAME', 'wordpress'); // database name define('DB_USER', 'username'); // MySQL username define('DB_PASSWORD', 'password'); // MySQL password define('DB_HOST', 'localhost'); // MySQL Host address ?> |
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
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.
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.
How about user privilege access? How can I do that in Plesk?
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.
This was very helpful. Worked for me the first time. Thanks!
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?