Tutorial Learning: How to Create MySQL Database with Phpmyadmin

ariefmunanzar(50)

Published in

#learn

Words

486

Reading

3 min

Listen

Play

Once the XAMPP application is installed and the wordpress file has been downloaded, the next step is to create a MySQL database that will be used during the installation of worpdress. In this tutorial, we will discuss the steps.

Run Web Server and MySQL

The first step we must do is to run Apache Web Server and MySQL database application. Both of these applications run from the XAMPP Control Panel window

If the XAMPP Control Panel window is not already open, Please select the menu from START-> All Programs-> XAMPP-> XAMPP Control Panel

In the XAMPP Control Panel view, click the Start button on the Apache and MySQL sections, as shown in the image below:

After the indicator turns green on both modules, open the web browser and type the address: localhost in the address bar and press Enter.

If there is no problem, in the web browser will display the home window of XAMPP. Next, we will create a database that will be used by wordpress.

How to Create MySQL Database with Phpmyadmin
After XAMPP on localhost runs successfully, the next step is to create a MySQL database.

WordPress uses a MySQL database to store all the settings, articles, and comments that are on the website. Because of that this time we will make 1 piece of MySQL database.

To create a MySQL database, I use the default XAMPP application, which is Phpmyadmin. Phpmyadmin is a GUI (Graphical User Interface) application for MySQL based web, so we can create, delete, and perform (almost) all MySQL commands via web view.

To open Phpmyadmin, please click Phpmyadmin menu in Tools section on localhost start page, as shown below:

Next will appear Phpmyadmin start page. To create a new database, click the Databases menu on the top left of the page, as shown below:

In this section of the database, please enter the name of the database you want to create in the "Create database" field. You are free to use any database name, in this example I use the database name: wordpress_db. I added "_db" which stands for database. It is just a habit to differentiate it from other variables, by making wordpress_db, I can immediately tell that this is a "database".

After naming the database, the next field is "Collation". Collation is a procedure or rules of arrangement of letters, numbers and characters in the database table. You can leave the 'default' option available: Collation, or choose utf8_general_ci.

From the wordpress documentation at http://codex.wordpress.org/Glossary#Collation, wordpress suggests using collation utf8_general_ci. Please select this collation type, then click "Create" button to create a new database.

Moments later, confirmation will appear that the database "wordpress_db" has been successfully created. You can check it from the list of available database tables in MySQL.