In creating a database, we will know the name SQL. SQL is a set of commands used to access data in a relational database. While technically, SQL is a computer language that follows the American National Standard Institute (ANSI) standard used for relational database management. With the SQL programming language, we can access the database, run queries to retrieve data, add data, delete data, and change data in the database. Today, almost all existing database servers support SQL as their data management programming language.
To master database management, you must master the SQL language. That, why, all of the best IT campuses in Indonesia taught database management using SQL. In fact, SQL language is the language taught in courses in informatics engineering and also information systems. Therefore, you need to know how to manage the database using SQL language.
To use SQL language, we can use various methods. Before you manage the database, you definitely need to create a database. How to do it? In our previous article, we provided information on how to create a database with mySQL the relational database management system (RDBMS) created by Michael Widenius, before finally being acquired by Oracle.
Now, on this occasion, we will discuss how to create a database with phpMyAdmin. If you are not used to using commands in the Command Prompt, you can create a database on localhost with phpMyAdmin.
phpMyAdmin is a web-based GUI (Graphical User Interface) application, so we can create, delete, and do (almost) all MySQL commands through web display easily. phpMyAdmin supports many operations in MySQL and MariaDB, such as managing databases and other database components, such as tables, relations, columns, users and more. So, actually you use MySQL in database management when you use phpMyAdmin. The difference is only found on a display that makes it easier for users.
This can be made by creating a graphical display from MySQL with phpMyAdmin because MySQL is one of the most open database software for all open cource and can be used for all platforms, from Linux to Windows. The advantage of this database software is its use that can be used for multi-users, because the database accessers in this software use programs that are networked or online (in the network). they are offline. Where, this application is usually available on localhost server software, such as XAMPP and WAMP Server. If in the previous way, you should connect with the web server that you are using, in this way, you can manage the database offline and without using the internet. This is because the computer or laptop that you are using will be used as a "server" called "localhost".
Therefore, the methods we will provide the following are intended for the management of databases located on web servers or hosting that you rent. . To create a database with phpMyAdmin, please follow the steps below.
1. Install XAMPP or WAMPServer
Before starting, download the XAMPP or WAMP server software through the WAMP Server link and the following XAMPP link . Once downloaded, install it on your computer or laptop.
2. Run the Web Server and MySQL
The next step we have to do is run the Apache web server and the MySQL database application. Both applications can be run from the XAMPP Control Panel window or from the WAMP Server program window.
If the XAMPP Control Panel window is not open, select the menu from Start> All Programs> XAMPP> XAMPP Control Panel. In the XAMPP Control Panel window, click Start on the Apache and MySQL section, as shown in the picture below:
After the background of the two modules becomes green and the words "Start" on the button changes to "Stop", open the web browser and type the address "localhost" in the address bar and press the Enter key on the keyboard.
If there are no problems, then in the web browser, a home window will appear from XAMPP, as shown below:
3. Open the phpMyAdmin page
After successfully running the XAMPP application on localhost, the next step is to create a MySQL database. If you use WordPress as your website's Content Management System (CMS), WordPress uses a MySQL database to store all the settings, articles, and comments that are on the website. Therefore, this time we will create a MySQL database.
4. Start creating a database
Then the start page will appear from phpMyAdmin. To create a new database, click the "Databases" menu at the top left of the page, as shown in the picture below:
In this part of the database, please enter the name of the database that you want to create in the "Create database" column. The database name can be anything or up to you. In this example, we use the database name "wordpress_db". We add "_db" which stands for database. This is just to distinguish it from other variables, by naming "wordpress_db" in the database, we can immediately find out that this is "database".
5. Set the Formulation of Letters and Save Settings
After naming the database, the fields that need to be set up are "Collation". Collation is the procedure or rules for the preparation of letters, numbers, and characters in a database table. You can just leave the default settings in Collation, or choose "utf8_general_ci".
From the WordPress documentation at the address http://codex.wordpress.org/Glossary#Collation WordPress advises its users to use utf8_general_ci in the collation. Therefore, choose this type of collation. Just then click the "Create" button to create a new database.
A few moments later, a browser confirmation window will appear. " wordpress_db "was successfully created. You can check it from the list of available database tables in the "Databases" phpMyAdmin page.
At this stage, the new MySQL database has been finished making. The result will be the same when you do how to create a database with MySQL which we reviewed earlier on this site.
Of all the steps we provided above, the point is to create a database with mySQL, it's quite easy. To create a database in MySQL, the command is as follows:
CREATE DATABASE cinema;
If successful, you can see the database that was created with the following command:
Our articles this time are about how to create a database with mySQL. Hopefully you can follow the tutorial that we provided in this article successfully. If you are interested in studying the database, read our article about the most complete SQL basic command on our site. Good luck and good luck.