Creation of MySQL Database through Parallels Plesk web control panel is a breeze. Simply follow this tutorial to create a MySQL Database for your WordPress. You can manage the MySQL Database through PHPMyAdmin for taking backup or other usages. There can be two situations where you will use Parallels Plesk :

Situation 1 : You have Installed Plesk on a Blank Server with own Parallels Plesk License Situation 1 : You have Installed Plesk on a Blank Server with own Parallels Plesk License

This is the situation is for the advanced server users who are using blank own colocated server, physically in premise server (or even own computer as Bare Metal), created image based cloud server instance from Amazon, Rackspace, HP, Media Template and other similar service providers. In this case, you need not use command line interface to create a MySQL Database for WordPress but simply follow our guide.

Top ↑

This is the most common for traditional web hosting providers for dedicated, virtual dedicated or shared web hosting account.

Top ↑

Steps to Create a MySQL Database and User in Plesk in Both Situations Steps to Create a MySQL Database and User in Plesk in Both Situations

These instructions will help you create a MySQL database along with a database user in Plesk.

To begin, log in to Plesk. If it is your first time working with Plesk and you are not entirely sure how to do that, read here. Once you are in, locate the “Databases” link in the top right corner of the screen and click it.

N.B. If you do not see the link, the most likely reason is that your subscription lacks the corresponding permissions or resources (or, plainly put, your hosting package does not include the ability to add MySQL databases). Talk to your hosting provider to resolve the issue.

Once you have clicked the link, you will find yourself on the database management screen. Here you can see and manage all databases you create for your domains. To add your new database, click Add Database.

Type in your desired database name and make sure to select the MySQL server from the “Database server” menu if more than a single option is available. You can also associate the database with a domain in Plesk, but this is merely a matter of convenience and will not affect the way your database functions (that is, you will still be able to use a database when installing WordPress on a domain even if you do not associate the database with the domain).

Now, it’s time to create a database user for the database. Make sure that the “Create a database user” checkbox is selected, and then type in the username and password for the database user. Make sure that you’ve picked a strong password! As in, capital letters. A pinch of numbers. Special symbols to taste. You know the drill.

We also recommend leaving the “User has access to all databases within the selected subscription” option alone unless you are sure that you need it.

Finally, if you wish, you can configure from where the user (this specific user, mind) can connect to the database.

By default, remote connections from anywhere are allowed. This is the most permissive option, but also one that offers the least in terms of protection. For the security minded, we recommend selecting “Allow local connections only” – this way you lose the ability to edit the database remotely, but drastically decrease the chances of your WordPress site becoming the target of hackers’ unwelcome attention. If you have a static IP address from which you wish to connect to the database, the “Allow remote connections from…” option offers you the best of both worlds.

Once you’re all done, click Ok to create your database. It will show up in the list, and you will always be able to access and manage it from the Databases menu (we spoke about it earlier in the topic, remember?) And while you’re here, let’s take a quick look at what you can do here.

  • phpMyAdmin will be your first port of call. A lightweight but powerful tool for managing MySQL databases that opens in your browser. Note that you can access and manage your database with this tool even if you specified the “Local connections only” option for the database user, as phpMyAdmin runs locally on the server.
  • Connection info shows you the information you need to connect to the database, including the host, database name, and the database user’s username. Make sure you remember the password though, as it will not be shown anywhere in plain text. If you’ve forgotten the database user’s password, read on.
  • Export and Import dump enable you to, respectively, back up and restore the database in native MySQL format. In addition, the import function will come in handy should you choose to move your WordPress blog to a different server.

 

Finally, the matter of the database user. If you’ve forgotten the database user password, click the username displayed right under the database name. This will take you to the database user properties page where you can set a new password (don’t forget to update the WordPress configuration files accordingly). Here you can also fine-tune the database user’s privileges, but we recommend leaving them alone unless you know what you are doing, as setting incorrect privileges may compromise your blog’s functioning.

And there you have it! One MySQL database, fresh from the oven. Continue installing WordPress following the instructions here.

Top ↑

Helpful Resources Helpful Resources

  1. Parallel Plesk – Official Website
  2. phpMyAdmin Wiki – Official Wiki of PHPMyAdmin