How To Create a MYSQL Database in 4 Simple Steps

Learning how to install a MySQL database is a good thing to know (I think)…

Since a lot of server side scripts / software require you to install a database on your server (domain) using MySQL. Even a manual WordPress install on your server will require you to setup a MySQL account (while you can install WordPress using Fantastico, there are some reasons why you may not want to do that… but that’s outside of the scope of this article).

This is a quick tutorial on how to create a MySQL database and user name for cPanel accounts (I recommend you get hosting with cPanel because it’s generally much easier to use than other platforms).

Step 1

Log-in to your cPanel. Generally your url for cPanel is:

http://YOURDOMAIN.com/cpanel

Once logged in, look for the MySQL Databases icon:

Once you’ve located the icon, click on it and you will get to a new screen.

 

Step 2

The first thing you need to do once you’re in the MySQL Databases screen is to create your database entry.

Enter your name, and click “Create Database”. Once you’ve completed the install, you can go back to the main MySQL database screen and you will see your new entry like this:

In the image above you can see that the field under “Users” is left blank. So in the next step you’re setting up a user…

 

Step 3

Once you’ve created your database entry, you will need to add a new MySQL user by entering a username and password:

I like to create a random password for my MySQL databases and use a simple Password Generator script to do this. I have one installed on this site that you can use as well, here: http://supersimplemarketing.com/pwgenerator/

 

Step 4

Now that you’ve created both your new database, username and password to go with it, your next step is to add the username to your new database (please make sure you pick the right username and database from the dropdown menu):

Select the right user and database and click “Add”. You will now be taken to a new screen where you will be presented with some options (for user privileges):

For most databases you will want to check the “All Privileges” box (which will check all of the boxes automatically).

Click “Make Changes”.

You have now finished creating your MySQL database and associated a user with all privileges to the database. You can verify that you’ve set it up correctly by looking at the “Current Databases” area:

What to do next?

You will now enter your MySQL database into whatever script installation that you are running. Here’s an example of what that would look like:

 

The “Database Host” is generally set to localhost (if it’s not, ask your hosting company).

Database Username, Password and Name (database name) are what you’ve just created, so simply fill that in accordingly.

And, that’s it.

Four Simple Steps to a MySQL install.

This Post Is Sponsored By:

• Get My Micro Niche Blogging Course! - Last chance to get your hands on my micro niche blogging course. Ends on March 31st!
• Micro Niche Blog - Let Me Build You A Niche Blog!
• Proven Niche Manifesto - Tested & Proven Profitable Niches - stop wasting time and start making money today!
• Immediate Cash Blueprint - Super Simple Profit Formula | Earn Money This Week!

 

Share and Enjoy

Tags: cpanel, mysql