There is a very interesting option for users of MySQL databases in the latest version of Cpanel (v11). They have created a little wizard for you to setup your MySQL Database. Well, I am thinking that that could mean that the “normal mode” of database creation in Cpanel is a little too tough for users, thus a wizard is needed. Hmm….anyway if you are feeling a little more adventurous, you can try my the other step by step tutorial on creating MySQL databases in Cpanel. Err…I don’t think it is that difficult for anyone to have to use a wizard. I always said that Cpanel is extremely easy to use. Do note that if your webhostis using a older version of Cpanel, then there will not be any wizard to help you along.

But no worries, if you find creating MySQL databases too tough or technical, I have created a little tutorial on using Cpanel’s MySQL Database Wizard. I am sure that even a 5 year old kid can do this without any problems. Just follow whatever instructions is on the screen and you should be alright.

So, go ahead and choose the MySQL Database Wizard under the Databases submenu.

Key in the name of your new database (in this example, it is “new”) and then click on Next Step.

There, the database is created. Note the name has changed. Usually, it will be prefixed with your domain name or a shortform of your domain name. Do remember the full name of your new database as you will need to fill in the entire name for your configurations. You will then be prompted to key in a username and passwords for your new database user. Do it and then click on Next Step. I would highly recommend you to create a complex password to prevent hackers from accessing or damaging your database.

As you can see from the above example, I have created a new user named “sgsmallb_newer” and the password for that user is cmv221d. You will need to remember the username and password. Note that like the database name, the username is prefixed as well. Keep them in a safe place for future reference. Furthermore, I have added the newly created user to the database as well. The next thing you need to do is to assign privileges to the user when accessing the database. No worries, for most cases, you will give them full access, so tick ALL PRIVILEGES. After that, click on Next Step to continue.

There, you are all done. Not so difficult right? Click on Return to Home. As you can see from the above photo, if you so desire, you can add another database (which starts the wizard again) or you can add another user to the database. However, this simple tutorial will not cover them.