How to create a database in Cpanel 11
For some scripts (like wordpress) you need to have a database that the script runs on. This post is a brief simple tutorial on how to create a database within CPanel 11, and is presuming you have no existing databases.
Log into your CPanel.
You need to click on the icon called MySQL databases.
In CPanel 11 it’s several sections down, in a section called Databases.
Right on top is the area to create a new database.
Type the name you want to give the new database in the empty box.
For this example, let’s call the database “mywp”.
Click create database.
You should get a message saying you’ve added the database “mywp”.
Click go back, so you can take the next step and create a user.
About halfway down the page there’s a section called MySQL users.
Type the name you want to assign to the user.
Create a password, and type it in twice.
Click “Add User” when you come up with a user name and password.
For this example, let’s call the user name “wp1″ and make the password “test”.
You should get a message saying you’ve added user “wp1″ with password “test”.
Lastly you need to assign the user you’ve created to the database you’ve made.
Within the MySQL users, look for the area that says Add user to database.
In the pulldown boxes, look for the user and database you’ve just created.
It’s important you know that your database and user name will also have your CPanel user name attached to it. So for this example, let’s say your CPanel user name is user1.
For this example the user name would be “user1_wp1″ and the database would be “user1_mywp”.
That’s it, you’re done!
