Creating MySQL Databases

A MySQL Database is a relational database management system. It runs as a server, providing access to a number of databases. It allows you to store a lot of information in an easy-to-access manner. The databases themselves are not easily read by humans, which is why you don’t need to read them. MySQL Databases are needed for installing some scripts and programs like Wordpress, XMB, Coppermine, etc. And for normal web-masters who need to install these kinds of scripts and programs only need MySQL for that purpose. So you don’t need to worry about editing any tables.

In order to use a MySQL Database, you’ll need to create one. Make sure that you have a cPanel (these usually only come with domains). And if you’re using a hosted subdomain, then your MySQL should already be created by your host.

1. Log into cPanel. Find the Databases section.



Click on MySQL Databases

2. A new page will come up. On the top-ish section it will tell you to create a new database. Enter a database name.



Click Create and a successful screen will come up



When you go back to the MySQL Database page, you will now see your database, but there is no user. So we have to make one.



3. Scroll down a bit on the MySQL Database page and find the section where it tells you to create a user. Type in the information and click Create.



After you’ve pressed Create a success screen will come up



4. Now we have to add the user to the database. Do this by going back to the MySQL Database page. Find the area where it says Add User to Database. Once found, select the user you’ve just created and the database you’ve just created.



5. Then a page will come up telling you to manage the user privileges. I’d just select All Privileges.



After that click Save Changes. And the user will be added to your database.



You see where before the user area was blank, it’s now there