MySQL
Thebestindonesia.com – MySQL is a DBMS that was first developed in 1994 by a software company called TcX Data Konsult AB which later changed the label to MySQL-AB. MySQL-AB was founded by two people with Swedish citizenship and one Finnish citizen, namely David Axmark, Allan Larsson, and Michael Widenius. ‘My’ in the word MySQL doesn’t mean MY in English but is said to be the name of the daughter of Michael Widenius. Another version says, ‘My’ is short for ‘Monty,’ which is a nickname for him. After several ownership changes, MySQL is owned by Oracle Corporation, a large-scale database company (which previously also had the most popular DBMS, Oracle).
MySQL is used by most of the Web Servers in the virtual world. Besides being simple, MySQL can also be ported to various server-class operating systems such as Windows, Linux, Solaris, Mac OS, BSD, Unix, and IBM-AIX. Even though it is relatively simple, MySQL has outstanding features that make it suitable for implementing database applications, especially Web-based ones.
MySQL architecture
MySQL works in a network environment using a client/server architecture. A program runs as a server, and various clients send requests to the server.
MySQL has the following components:
MySQL Server, or I, is a database server program. This program manages access to the database on disk and memory. MySQL Server is multi-threaded and supports multiple connections simultaneously. MySQL Server has a modular architecture, so it supports a variety of storage engines to handle several types of tables.
Client program is a program used to communicate with the server to manipulate information in the database handled by the server.
✔ MySQL Query Browser and MySQL Administrator provide a graphical interface for access to the server.
✔ MySQL, a command line program for access to text-based servers.
✔ Other command line programs, such as mysqlimport to import database to file, mysqldump to make backups, mysqladmin for server administration, and mysqlcheck to check database file integrity.
Read also : Data Definition Language (DDL)
MySQL non-client utilities, programs that act independently of the server. These programs don’t need to connect to the server beforehand to operate. Example: myisamchk for table checking and repair operations.
Activate MySQL
The way to activate MySQL is to use XAMPP’s help through the following steps:
a. Windows START ⭢ XAMPP ⭢ XAMPP Control Panel
b. Click START Apache and MySQL
Read also : Data Manipulation Language (DML)
Access MySQL Using Command Prompt
a. How to activate the Command Prompt with the following steps: Windows START ⭢ cmd
b. To be able to access MySQL, you must first activate the MySQL server by turning on the MySQL daemon. The MySQL daemon directory is adjusted to the location of XAMPP on the computer. The steps are as follows:
shell> cd c:\xampp\mysql\bin
Connection and Disconnection to the Server
a. Connection to Servers
MySQL can manage users in accessing the database. So not just any user can access a database that MySQL created. When you don’t have a User to access MySQL, MySQL database access, in general, can use User Root. To connect to the MySQL server via User Root, use the following command:
shell> MySQL –u root
b. To find out the connection status to MySQL by, using the command as follows:
mysql> STATUS;
c. Disconnection to Server
To disconnect from the MySQL server use the command as follows:
mysql> quit or mysql> \q
Help with MySQL
Does the MySQL database provide several useful assistance facilities for documenting or manipulating the server by typing the command \h or \? All queries must end with a semicolon (;). This sign indicates that the query has ended and is ready to be executed.
Prompt | Description | |
Help | \h | View help on MySQL |
? | \? | Same with the Help command |
Clear | \c | Clears or aborts all commands that have been running |
Connect | \r | Re-connect to the existing database on the Host Server |
Ego | \G | Displays data horizontally |
Go | \g | Gives commands to Server to execute |
Tee | \T | Set where the file will be documented |
Notee | \t | End of (\T), to document all queries |
\p | Prints all the queries we have typed on the screen | |
Prompt | \R | Change the default prompt as desired |
Source | \. | Executes external queries in the form of .sql |
Use | \u | Enter the database to be used, or change the database to be used |