MySQL 64 bit 8.0.11

MySQL is a truly multi-user, multi-threaded structured query language database server. SQL is the most popular database language at present.

Introduction to Software Basics

MySQL is a relational database management system, developed by Sweden MySQL AB, and currently belongs to Oracle. MySQL is a relational database management system. The relational database stores data in different tables instead of putting all data in a large warehouse, which increases speed and flexibility. MySQL's SQL language is the most commonly used standardized language for accessing databases. MySQL software adopts a dual authorization policy (this term "authorization policy"), which is divided into community version and commercial version. Because of its small size, fast speed, low overall cost of ownership, especially the open source, MySQL is generally selected as the website database for the development of small and medium-sized websites. Because of the excellent performance of its community version, it can form a good development environment with PHP and Apache.

Software features

High speed

High speed is a prominent feature of MySQL. In MySQL, extremely fast "B-tree" disk tables (MyISAM) and index compression are used; By using optimized "single scan multiple connections", extremely fast connections can be achieved. High speed has always been one of the features that MySQL attracts many users, which can only be realized by personal use.

Support multiple platforms

MySQL supports more than 20 development platforms, including Linux, Windows, FreeBSD, IBM AIX, HP-UX, Mac OS, OpenBSD, Solaris, etc. This allows users to choose multiple platforms to implement their own applications, and application systems developed on different platforms can be easily migrated between various platforms.

Support various development languages

MySQL supports various popular programming languages and provides them with many API functions, including C, C++, Java, Perl, PHP, etc.

Provide multiple storage engines

The latest official version of MySQL provides a variety of database storage engines. Each engine has its own advantages and is suitable for different applications. Users can choose the most appropriate engine to get the highest performance.

Powerful

The powerful storage engine enables MySQL to be effectively applied to any database application system and efficiently complete various tasks, whether it is a high-speed transmission system for a large amount of data or a high-intensity search website with more than hundreds of millions of visits every day.

Support for large databases

The InnoDB storage engine stores InnoDB tables in a tablespace that can be created by several files. In this way, the size of the table can exceed the maximum size of a single file. The table space can also include raw disk partitions, making it possible to build large tables with a maximum capacity of 64TB.

Security

Flexible and secure authority and password system, allowing host based authentication. When connecting to the server, all password transmissions are encrypted to ensure password security.

Low price

MySQL is licensed under GPL. In many cases, users can use MySQL for free; For some commercial purposes, you need to purchase a MySQL commercial license, but the price is relatively low.

Installation steps

1. After downloading, double click and unzip it. Double click to start the installation program corresponding to your system version, and then click [NEXT]

2. Enter the installation protocol interface and check I accept, Then click [NEXT].

3. In the installation type selection interface, it is recommended to select Typical installation. If you need other options, please select Full or Custom type for installation settings

4. Prepare the installation program interface and click Install

5. Finally, select Finish to complete the installation.