How to create a MySQL Database
You might be asking why you would ever want to create a mysql database? Good question. The long answer is here.
The short answer is because WordPress stores all your blog’s data in a MySQL database located on your server.
(And its one of the requirements of using WordPress.)
Log in the the cpanel of your hosting account.
Look for the ‘Databases’ section:
Click on the MySQL Databases icon.
This is where you can create a database for your WordPress site. Its very simple to use. There are four steps involved.
The 4 steps are
- Create the database
- Create the user
- Attach the database & the user
- Assign priviledges to the user
1. Create the Database
Just give it any name and make a note of it. The name will always be comprised of your hosting account name and the part you name it, like this:
Once you click ‘Create Database’, then scroll down the page till you see this:
2. Create a MySQL User
Type in a username and password, then make a note of both. The full username is composed of the hosting account name and the part you create.
Click Create User and then scroll down to here:
3. Attach the Database and the User
Choose the username and the database you just created, click Add.
When you click Add, it’ll take you to this screen:
Check the box at the top that says ‘All Privileges’
Then click ‘Make Changes’