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.
;)
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’:
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’:
<?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.
I hope you this tutorial were helpful for you. You can see more Plesk tutorials in our server management section.
Need a specific tutorial? Do not hesitate and submit a request!
posted on 2009-Nov-01 | 10:33:56 PM
posted on 2009-Dec-29 | 09:28:56 PM
posted on 2009-Dec-30 | 03:07:51 PM
posted on 2010-Jan-29 | 08:16:22 PM