MySQL database management for Plesk users

Create or add an additional database in plesk

To create a database driven website,and making a website dynamic you will need at-least one database associated to your website. In database driven website, web pages are served from rows of a database table instead of static HTML pages.

Step#1: Login to your Plesk panel as an “admin” or “re-seller”, or as a customer. Then click “Websites & Domains” from the left pane.

Step#2: Navigate “database” tab top-left corner of the window, just under the “backup-manager” tab.

Step#3: Click “Add Database”.

Step#4: Fill up the form. In the “Related site” field, choose the domain you want to associate the database with. Then create database user. Leave the ” user access to database….” unchecked, if you are not going to use all the databases under one user name. 

Note: It is always good to create new user for a new database. More secured.

Step#5: Its up to you whether you want to allow remote server access the database or not. Select the button as you like.

Step#6: To get the database connected with any database client like Heidi SQL. You will need to know database_name, database_user_name, db_user_password, database_server and hosting server IP address.

I hope, now you can create or add a database in plesk. 

Copy an existing database to another existing or new database within plesk

Keeping an extra copy of database is a common practice. You might need to work on a live site for updating project data. In such case keeping a copy of the database is very important. You might tend to “import/export” from PhpMyAdmin panel. Well copying a database is just another easy way to do it. Here is how to do it –

Step#1: Login to your Plesk panel as an “admin” or “re-seller”, or as a customer. Then click “Database” from the left pane.

Step#2: Scroll down and find “copy” from the database dashboard. Click “copy”

Step#3: Fill up the form accordingly. In the “Destination database” option, choose “create database with name”. If you have created an empty database first or want to copy into an existing database then choose the second option.

Step#4: Always check the “create full copy” option, Unless you want to populate the copied database with completely new data.

That’s it. This is so easy and quick to keep a database backup. Specially when you upgrade WordPress, Drupal or Joomla websites you will realize the power of this tool.

Add a new database user for an existing database within plesk

Sometimes you might need to give access to a single database to multiple developers. You might have multiple databases under one user name. But you just want to give access to specific database to the developer. In that case, you will have to create a new database user and assign that particular database to the new user. In this way one database can be used by different user. Let’s see how to do it –

Step#1: Login to your Plesk panel as an “admin” or “re-seller”, or as a customer. Then click “database” from the left pane.

Step#2: Make sure you have one or more existing database already. If you don’t see any database there, you don’t need to create a user separately. You can create user at the same time you create a database.

Step#3: From the top right corner navigate “user management” link. You will see an existing database user or list of users. Click “add database user”.

Step#4: Fill up the form with necessary information. In the “database” drop-down option, select the particular database you want to assign this new user to.

Note: From plesk panel you will see two options. Either assign the user for one database or any. In case you want to create one user who can access multiple databases but not all. Then you can do it from DB Webadmin panel.

Step#5: Click “OK” and test the login from https://yourdomain.com/phpMyAdmin 

I hope now you will be able to create a new database user for any existing database from within the plesk panel. 

Leave a Reply