If you are ready to make your own website, first of all you will need a hosting plan, for a blog I recommend something cheap because at start you will not have a big traffic. Search on Google low traffic hosting plan, this might help you find an appropriate web hosting. Next step is to find a platform for your blog, I recommend WordPress, its very simple to use and efficiently. Before installing WordPress you will need to create a MySQL database using your cPanel from your hosting plan.
1.Fist of all, you need to know what is a MySQL database.
A database is a way to store big collection of data that can be easily accessed using MySQL which is just a program that lets you store and retrieve that data as efficiently as possible.
A database program is a type of computer software that is designed to handle lots of data, and to store them efficiently.
2.What is SQL? What is MySQL?
Most of computer programs and web-based programs need to be store and retrieve requested data. For example on your new blog, when you make first post (HELLO WORLD!) your job is just to white, and the content will be retrieved to a visitor using MySQL database. This is available for all the content stored on your website.
To make it easy for other programs to access data through them, many database software support a computer language called “SQL” (often pronounced as “sequel”). SQL was specially designed for such a purpose. Programs that want the database software to handle the low-level work of managing data simply use that language to send it instructions.
3. Create new a database & a database user in cPanel
Database creation steps:
- Open MySQL® Databases Wizard (figure 1)
Figure 1- Open MySQL Databases
- Create your database (type the name of your database) and click on create database button.(figure 2).
Figure 2- Create Database
- After you have created the database, you will get this confirmation window (figure 3).
Figure 3- Confirmation window
Job done, the database is created.
4. Next step is to create a user for your database.
Figure 4- Create a user for your database
Figure 5- Confirmation window for newly MySQL user created.
5. Next step is to assign a user to database. You can do this at MySQL databases, select user and database that you want to be assigned. After this steps, you need to set all privileges for your user.
Figure 6- Assign user to your database by clicking add button.
6. Set all privileges for your user account.
Figure 7- All privileges for your user account.
7. Install WordPress manually:
- First you need to download WordPress from here. I recommend to install a stable version of WordPress (not the latest).
Figure 8- Download most stabile wordpress version.
- Next step is to create a FTP account and upload WordPress files to your server via ftp client (using your ftp account).
Figure 9- Open FTP accounts to create new account.
First you need to know what is FTP. What is FTP ? FTP allows you to manage the files that are associated with your website through an FTP client such as Filezilla or other.
- Fill in your new FTP account login details and click on create FTP account.
Figure 10- Create FTP account.
- Next step is to connect with your ftp account using a ftp client (in my case filezilla) and upload your WordPress zip file.
Figure 11- Upload your wordpress files using FTP account.
- Starting the WordPress installation in a Browser.
After upload navigate to your website and go through the installation process. If you have uploaded WordPress in your public_html directory you’ll need to go to http://yourdomain.com in your preferred browser. After you select your wordpress language, you will notice a message, telling you: there doesn’t seem to be a wp-config.php file. You will need to create this file before can get started.
Figure 12- Select your blog language.
- Welcome to WordPress. Before getting started, we need some information on the database. You will need to know the following items before proceeding.
Figure 13- You will need the following information before starting installation.(but you already have them all).
- Submit the details of your newly created database.
Figure 14- Submit requested details.
- After you have entered the necessary information, you can pres the Run the Install button to proceed.
Figure 15- Run the install.
- Great job!Now you have this message : Welcome to the famous five minute WordPress installation process! You may want to browse the ReadMe documentation at your leisure. Otherwise, just fill in the information below and you”ll be on your way to using the most extendable and powerful personal publishing platform in the world. Once you fill in the information, press the Install WordPress button.Be aware! You should provide real information (your real email adress).
Figure 16- Install WordPress.
- WordPress have been installed.
Figure 16- Log in intro your account and chose your favorite theme and plugins.
- Final step is to setup your favourite theme and plugins, and start writing….
Figure 17- Chose your theme and start writing
Source 1.: http://www.thesitewizard.com/faqs/what-is-mysql-database.shtml
Source 2.: https://ithemes.com/tutorial-create-database-in-cpanel/