You are here: Home » FAQ » How To Add A MySQL Database

How To Add A MySQL Database

Video Tutorial

First up is a video tutorial. Remember, if you cannot see it clearly, click on the 'Full Screen' option at the bottom right.

Text Tutorial

In order to set up php scripts that require a MySQL database you will first need to create such a database inside Plesk. Scripts have no permission to create databases on the 3DPixelNet servers.

Log into Plesk using the details found in your welcome email.

Select the domain you wish to add a MySQL database for and in the resulting window click Databases.

From there click Add New Databases. Please note if you already have databases set up, a summary will be displayed on this page.

Please select a suitable database name that you can remember. Please note, if you select a common name such as "database" it may already be taken by another customer, you will be prompted to reenter a name.

Once complete, you will need to add a verified user to the database. Click Add New Database User.

Again, enter a username and password you can remember. You will be prompted if any part is not accepted.

Submitting this will bring you back to the database summary window.

Commonly, scripts will ask for 4 things.
Server, Database Name, Username, Password.

3 of these values you have just created, Database Name, Username and Pasword. With all Scripts the Server is always localhost.