MySQL means database; instance; management; configuration; relational database.

1. Introduction to MySQL

MySQL is a relational database management system developed by the Swedish MySQL AB company and is a product of Oracle. MySQL is one of the most popular relational database management systems. In terms of WEB applications, MySQL is one of the best RDBMS application software.

MySQL is a relational database management system. A relational database stores data in different tables instead of putting all data in one large warehouse, which increases speed and flexibility. .

The SQL language used by MySQL is the most commonly used standardized language for accessing databases. MySQL software adopts a dual licensing policy and is divided into community version and commercial version. Due to its small size, fast speed and low total cost of ownership, especially its open source characteristics, MySQL is generally chosen as the website for the development of small, medium and large websites. database.

2. MySQL application environment

Compared with other large databases such as Oracle, DB2, SQL Server, etc., MySQL has its own shortcomings, but this does not reduce it at all. Its popularity.

For general individual users and small and medium-sized enterprises, the functions provided by MySQL are more than sufficient, and because MySQL is open source software, it can greatly reduce the total cost of ownership.

Linux as the operating system, Apache or Nginx as the web server, MySQL as the database, and PHP/Perl/Python as the server-side script interpreter.

Since these four software are all free or open source software (FLOSS), you can use this method to build a stable and free website system without spending a penny (except for labor costs). It is called "LAMP" or "LNMP" combination in the industry.