About me Domain Credits Way out Refresh My blog My host Credit


October 01, 2018 ♥ v23 layout (Halloween theme!) September 07, 2018 ♥ v22 layout ♥ 8 backgrounds/patterns ♥ 4 textures ♥ 20 gradients ♥ 4 banners ♥ 40 colors ♥ 2 photoshop tutorials ♥ 4 miscellaneous tutorials April 03, 2018 ♥ v21 layout ♥ 10 backgrounds/patterns ♥ 14 textures ♥ 10 gradients ♥ 50 colors December 17, 2017 ♥ v20 layout ♥ new blog entry ♥ 6 gradients ♥ 6 banners ♥ 6 colors November 03, 2017 ♥ v19 layout ♥ new blog entry ♥ 10 textures ♥ 10 gradients (new category!) ♥ 2 banners ♥ 10 colors ♥ revamped links & pages July 16, 2017 ♥ new layout (v18) ♥ new blog entry ♥ 6 backgrounds/patterns ♥ 8 premade banners ♥ 10 color schemes (revamped) May 25, 2017 ♥ new layout (v17) ♥ new blog entry ♥ 16 color schemes ♥ 1 photoshop tutorial ♥ 1 miscellaneous tutorial


Terms Back pats Banners Textus Colors HTML Tuts CP Tuts Ps Tuts PHP Tuts Misc. Tuts


Welcome to Sasha's gfx corner Skyrose, here to provide quality resources since May 2014; take a look, read the Terms, grab whatever you like and enjoy. <3

chat with me

mysql database tutorial

Some of the most common news publishing tools and scripts - i.e. FanUpdate and Wordpress - need a MySQL database in order to work. I won't get into details about what exactly is MySQL, mostly because you don't need to know that; you just need to know how to create a database and that is what I'm gonna show you.

This tutorial requires you to your own cPanel with Softaculous Installer - 90% of the hosts uses cPanel, so it's not hard to get one; if you have that, go on reading.

First thing first, login into your cPanel with the username and password your host gave you - cPanel url is generally located at your-domain.com/cpanel, but it can also be https:://your-domain.com:2082 or https:://your-domain.com:2083; the login page should show something like this.

Insert the required data, and you should see a page similar to the one below; that is the main page of cPanel.

Scroll the page until you find the section called Databases, and click on the MySQL Databases icon - you can see how the icon looks like in the screenshot below.

Once inside the page, fill the required field as shown in the screenshot - click to see the large version.

After your database has been created, you need to add the user to the database; you do so by selecting your database and the user you want to add to it, and then click Add. You'll be taken to the page below; select the All Privileges on the table top and hit the Make changes button.

A green popup like the one in the screenshot down here should come out, indicated you did it right.

Congratulations! You successfully installed your MySQL database; now you're free to install FanUpdate or any other CMS script requiring a database. ^_^