Creating a Database in Plesk Control Panel
Plesk gives you the ability to create MySQL databases in both its Linux and Windows forms; if you purchase the necessary add-ons then it can also connect to PostgreSQL and MSSQL servers to create both types of database; PostgreSQL is only normally found on Linux, and MSSQL is for Windows hosting only. Third party web based database control panels are built into Plesk and Plesk automatically logs you in to the relevant one when you want to administrate a database over the internet from a location that might happen to not be your own computer; in the case of MySQL databases, PHPMyAdmin is supplied to allow you to manage any MySQL databases that you might have hosted within your shared Plesk website hosting account – if you are hosted on the Windows platform and are utilizing Microsoft SQL databases then ASP.NET Enterprise Manager is supplied to allow you to view and manage any MSSQL databases that you have hosted under your account.
In most cases you will be using a database along with a dynamic web page language within your website so that your website is able to communicate with the database so it can pull data to be displayed, as well as store it within the database so that it can be easily accessed again. Plesk also gives you the ability to create users so that the databases you create can be accessed by the scripts that you have created within your web space; without these database users, scripts and other programs that you want to use to access your database or databases won’t be usable since they won’t be able to access the database.
Since Plesk gives you the ability to create multiple databases under many different database platforms, it gives you the ability to host many different web applications in a number of dynamic server side scripting languages so that the applications that you do create can easily interact with the databases that you have created within your shared Plesk website hosting account.
Creating a MySQL Database
In order to create a MySQL database from within Plesk, you will first need to navigate to the hosting control panel for the domain that you want to create the new MySQL database for. If you don’t know how to find your way to the hosting control panel for the domain that you want to create a new MySQL database for them you should take a look at this article; in the article noted you will also find other Plesk related tutorials which will help you get your new website off the ground in your new Plesk website hosting account. Once you have reached the hosting control panel for the domain which the MySQL database is going to be created for, you will need to select the ‘databases’ icon:
You should then be presented with the following screen, which also provides you with options to manage the databases that you might have already created using the Plesk control panel:
You will then need to select the ‘add new database’ icon, which will then redirect you into the database creation wizard. Once redirected, you will be asked to enter the following details:
- database name (circled red) – this is the name that you want to give the actual database, Plesk suggests that you begin the database name with your Plesk login followed by an underscore, it is after the underscore that you should enter the desired database alias
- database type (circled green) – this is where you select what database program you want the new database to be created in, if there is no more than one option then this field will not be shown – in the cases of Windows based Plesk website hosting, you are able to choose between MySQL and MSSQL databases, although the options are dependent on what database engines your web host has installed on your hosting server and what options they have enabled within their Plesk license. In our case we want to be creating a MySQL database.
One you have clicked the ‘ok’ button after entering the relevant details to aid in the creation of your database, you will be redirected to the management screen for the database that you have just created. In order to make your database usable from within your web pages and server side scripts that you have hosted within your hosting account, you will need to select the ‘add new user’ option:
You will then be prompted to enter the following details to aid in the creation of your database user:
- database username (circled red) – this is the username that you will use to gain access to your newly created database externally, for example from a script or web page that you are hosting within your Plesk hosting account or from your desktop database management browser if you have chosen not to use the supplied third party web based database management system
- password (circled green) – it is highly important that you password protect your newly created database user, since hackers might be able to gain access to your database and steal the data contained if the user account concerned doesn’t have a password on it.
Once you have done that, you should then be able to use the provided details to gain access to your new MySQL database from your PHP and ASP based scripts and web pages that you are hosting within your web space, you will also be able to use a desktop database management program to manage the contents of your new MySQL database.
One thing to note is that the ability to create MSSQL or PostgreSQL databases in the Windows and Linux versions of Plesk, respectively, is dictated by the Plesk license that your web host has installed on your web hosting server. For example, it costs extra for a web host to purchase a Plesk license that enables them and their clients to have access to MSSQL database creation and management facilities, and the same can be applied to PostgreSQL even though it isn’t a database engine that is widely used these days. Also, the third party management programs for databases that have been created in Plesk are dependent on what your web host has installed on your hosting server, which means that if you don’t want to use a certain program then you might have to resort to using a desktop based database management system, and these tend to have more features than web based systems meaning that you will have more control over your databases.
Like this post ?
Share on your Social Networking Profile ( Facebook, Twitter & Google+ ) and get a flat 10% Recurring discount on our VPS Hosting and Dedicated Servers.
Email us the shared link at : [email protected] or speak to our live chat operator now, by clicking on the “Live Chat” Scroller on the left-hand side of this page and we will provide you with the discount Coupon right away!