Step 1: How to create and set up a Database
1. Creating your database
First, you need to log in to cPanel. You will find it when you load http://www.yourdomain.com/cpanel
When you do, you see the screen below:
Click ‘MySQL Databases’ (see the red arrow)
A new screen will appear, showing you a list of all your existing databases and
database users:
Scroll down until you see a field and a button that says ‘Create Database’.
Click ‘Go Back’ to go back to the previous page.
On that page, scroll down until you see two fields and a button that says ‘Create User’.
Give your database a name and click the ‘Create Database’ button.
A new window appears, confirming your action:
Click ‘Go Back’ to go back to the previous page.
On that page, scroll down until you see two fields and a button that says ‘Create User’.
Choose a username and password, and click the button.
The confirmation screen will appear again. Click ‘Go Back’ to go back to the
previous page.
On that page, scroll down until you see ‘Add Users To Your Database’.
In the first drop down menu, select the user you just created. In the second drop
down menu, select the database you just created.
Make sure the box next to ‘ALL’ is checked.
Click the button that says ‘Add User To Database’.
Again you will see a confirmation message. Click ‘Go Back’ to go to the previous
page.
NOTE: a prefix has been added to the database name and username you
entered. Make sure to always include that prefix when you need to add your database info in a script!
Scroll down until you see ‘Access Hosts’. Make a note of what’s written there
(usually, this will be ‘localhost’).
Your database has been created and by now you have all the info you need to run your script’s installer (or to manually edit the script’s configuration file):
• your database name
• your database username
• your password
• your host
1. Creating your database
First, you need to log in to cPanel. You will find it when you load http://www.yourdomain.com/cpanel
When you do, you see the screen below:
Click ‘MySQL Databases’ (see the red arrow)
A new screen will appear, showing you a list of all your existing databases and
database users:
Scroll down until you see a field and a button that says ‘Create Database’.
Click ‘Go Back’ to go back to the previous page.
On that page, scroll down until you see two fields and a button that says ‘Create User’.
Give your database a name and click the ‘Create Database’ button.
A new window appears, confirming your action:
Click ‘Go Back’ to go back to the previous page.
On that page, scroll down until you see two fields and a button that says ‘Create User’.
Choose a username and password, and click the button.
The confirmation screen will appear again. Click ‘Go Back’ to go back to the
previous page.
On that page, scroll down until you see ‘Add Users To Your Database’.
In the first drop down menu, select the user you just created. In the second drop
down menu, select the database you just created.
Make sure the box next to ‘ALL’ is checked.
Click the button that says ‘Add User To Database’.
Again you will see a confirmation message. Click ‘Go Back’ to go to the previous
page.
NOTE: a prefix has been added to the database name and username you
entered. Make sure to always include that prefix when you need to add your database info in a script!
Scroll down until you see ‘Access Hosts’. Make a note of what’s written there
(usually, this will be ‘localhost’).
Your database has been created and by now you have all the info you need to run your script’s installer (or to manually edit the script’s configuration file):
• your database name
• your database username
• your password
• your host