Shulou(Shulou.com)06/01 Report--

MySQL is a relational database management system in which relational databases store data in different tables instead of 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 the dual licensing policy, which is divided into community version and commercial version. Because of its small size, high speed and low total cost of ownership, especially open source, the development of small and medium-sized websites generally choose MySQL as the website database.

The installation process of mysql server5.5

1. The first thing to enter is the installation boot interface

2. Then enter the type selection interface, where there are three types: Typical (typical), Complete (complete), and Custom (custom). It is recommended to choose "Custom" installation, so that you can customize the installation directory of MySQL, and then click "Next" next step, a custom installation interface appears. For the sake of data security, it is not recommended to install the C directory of MySQL system disk.

3. Prepare for installation

4. After the installation is completed, the boot interface for MySQL configuration will appear.

5. Here is an option to boot and configure MySQL (Luanch the MySQL Instance Configuration Wizard). It is recommended to check to configure your MySQL immediately.

6. Here is the type of MySQL configuration for configuring MySQL. You can choose two configuration types: Detailed Configuration (detailed configuration) and Standard Configuration (standard configuration).

The Standard Configuration (standard configuration) option is suitable for new users who want to start MySQL quickly without considering the server configuration. Detailed configuration options are suitable for advanced users who want more fine-grained control over the server configuration.

If you are new to MySQL and need to be configured as a single-user development server, Standard Configuration (standard configuration) should suit your needs. Select the Standard Configuration (standard configuration) option, and the MySQL Configuration Wizard (configuration wizard) automatically sets all configuration options, excluding service and security options.

The Standard Configuration (standard configuration) setting option may not be compatible with the system on which MySQL is installed. If MySQL is already installed on the system and the installation you want to configure, it is recommended that you choose detailed configuration.

Here I choose Detailed Configuration, want to better complete personalized customization.

7. Here is the MySQL server type for configuring MySQL. You can choose three server types, which server will affect the MySQL Configuration Wizard (configuration wizard) decision on memory, hard disk and process or use.

Developer Machine (development machine): this option represents a typical personal desktop workstation. Assume that there are multiple desktop applications running on the machine. Configure the MySQL server to use the least system resources.

Server Machine (server): this option represents the server, and the MySQL server can run with other applications, such as FTP, email, and web servers. The MySQL server is configured to use the appropriate proportion of system resources.

Dedicated MySQL Server Machine (dedicated MySQL server): this option represents a server that runs only the MySQL service. Assume that no other applications are running. The MySQL server is configured to use all available system resources.

Here I choose Developer Machine, mainly for peacetime development needs.

8. Here is the database usage for configuring MySQL. You can indicate the table processor used to create the MySQL table. With this option, you can choose whether to use the InnoDB storage engine and what percentage of server resources InnoDB takes up.

Multifunctional Database (Multi-function Database): select this option to use both the InnoDB and MyISAM storage engines and distribute resources equally between the two engines. It is recommended that users who often use two storage engines choose this option.

Transactional Database Only (just transaction databases): this option uses both the InnoDB and MyISAM storage engines, but allocates most server resources to the InnoDB storage engine. It is recommended that users who mainly use InnoDB and only occasionally use MyISAM to choose this option.

Non-Transactional Database Only (only non-transactional databases): this option completely disables the InnoDB storage engine and assigns all server resources to the MyISAM storage engine. It is recommended that users who do not use InnoDB choose this option.

I chose Multifunctional Database.

9. Here is the InnoDB tablespace for configuring MySQL, and some users may want to put the InnoDB tablespace files in a different location rather than in the MySQL server data directory. If your system has large space or high-performance storage devices (such as RAID storage systems), it is best to put tablespace files in a separate location. To change the default location of InnoDB tablespace files, select a new drive from the drive drop-down list and select a new path from the path drop-down list. To create a path, click. Button. If you want to change the configuration of an existing server, you must click the Modify button before changing the path. Before starting the server at this point, you must move the existing tablespace files to a new location. I choose the default configuration.

10. Here we configure concurrent connections for MySQL, and it is important to limit the number of parallel connections created to the MySQL server to prevent the server from running out of resources. You can choose how to use the server and limit the number of parallel connections as appropriate. You can also manually set limits for parallel connections.

Decision Support (decision support) (DSS) / OLAP: select this option if the server does not require a large number of parallel connections. Assume that the maximum number of connections is set to 100 and the average number of parallel connections is 20.

Online Transaction Processing (online transaction processing) (OLTP): select this option if your server requires a large number of parallel connections. Set the maximum number of connections to 500.

Manual Setting (manual setting): select this option to manually set the maximum number of parallel connections to the server. Select the number of parallel connections from the previous drop-down box, and if the desired number is not in the list, enter the maximum number of connections in the drop-down box.

Here according to personal needs, I choose Manual Setting.

11. Here is the network option for configuring MySQL. You can enable or disable TCP/IP network and configure the port number used to connect to the MySQL server. TCP/IP networking is enabled by default. To disable TCP/IP networking, deselect the check box next to the Enable TCP/IP Networking option. Port 3306 is used by default. To better access the port used by MySQL, select a new port number from the drop-down box or enter the new port number directly into the drop-down box. If the port number you selected is already occupied, you will be prompted to confirm the selected port number. If other machines need to access the database, it is recommended to check Add firewall exception for this port (add to the firewall exception).

12. Here is the character set for configuring MySQL. The MySQL server supports multiple character sets, and you can set the default server character set for all tables, columns, and databases. You can change the default character set of the MySQL server through Character Set (character set dialog box).

Standard Character Set (standard character set): select this option if you want to use Latin1 as the default server character set. Latin1 is used in English and many Western European languages.

Best Support For Multilingualism (supports multiple languages): select this option if you want to use UTF8 as the default server character set. UTF8 can store characters from different languages as a single character set.

Manual Selected Default Character Set/Collation (manually selected default character set / proofreading rules): select this if you want to manually select the default character set for the server. Select the desired character set from the drop-down list.

13. Here are the service options for configuring MySQL. You can install the MySQL server as a service. Installed as a service, the MySQL server can be started automatically when the system starts, and even when there is a service failure, it can be started automatically with Windows.

By default, MySQL Configuration Wizard (configuration Wizard) installs the MySQL server as a service, which is named MySQL. If you do not want to install the service, uncheck the selection box next to the Install As Windows Service option. You can change the service name by selecting a new service name from the drop-down box or entering a new service name in the drop-down box. To install the MySQL server as a service but not start it automatically, uncheck the check box next to the Launch the MySQL Server Automatically option.

14. Here are the security options for configuring MySQL. It is strongly recommended to set a root password for your MySQL server. By default, MySQL Configuration Wizard (configuration wizard) requires you to set a root password. If you do not want to set the root password, uncheck the selection box next to the Modify Security Settings (modify Security setting) option. To set the root password, enter the desired password in the New root password (enter new password) and Confirm (confirm) boxes. If you reconfigure an existing server, you also need to enter the existing root password in the Current root password (current root password) box. To prevent logging in via root over the network, check the box next to the Root may only connect from localhost (only allow local login to connect to root) option. This will improve the security of your root account. To create an anonymous user account, check the box next to the Create An Anonymous Account (create anonymous account) option. Creating anonymous accounts reduces the security of the server and makes it difficult to log in and license. Therefore, it is not recommended.

15. Confirm and click Excute to complete the installation.

These are the details of what is the installation process of mysql server5.5. Please pay more attention to other related articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.