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

Mysql installation, configuration, optimization, for your reference, the details are as follows

Mysql download

First log in to the official website to download the installation package of mysql, then drop down the address of https://dev.mysql.com/ on the official website, and finally select MySQL Community Server in downloads.

Select the version you want to download

MySQL installation

1. Open the downloaded mysql installation file mysql-5.5.43-win32.rar, double-click to extract it, and run "setup.exe".

2, select the installation type, there are "Typical (default)", "Complete (complete)", "Custom (user defined)" three options, select "Custom", press the "next" key to continue.

3. Click "Browse" to specify the installation directory manually.

4. Fill in the installation directory. Mine is "C:\ Program Files (x86)\ MySQL\ MySQL Server 5.5" and press "OK" to continue. After confirming this path, continue to click Server data files, also need to modify the path, this file saves the database code written in mysql to confirm the previous settings, if there is any error, press "Back" to return to redo. Press "Install" to start installation.

5. Please wait until the following interface appears to complete the installation of MYSQL while you are installing.

MySQL configuration

Choose the configuration method, "Detailed Configuration (manual precise configuration)", "Standard Configuration (standard configuration)", we choose "Detailed Configuration" to facilitate familiarity with the configuration process.

Select the server type, "Developer Machine (development test class, mysql takes up less resources),"Server Machine (server type, mysql takes up more resources)", "Dedicated MySQL Server Machine (dedicated database server, mysql takes up all available resources)"

Select the general use of mysql database, "Multifunctional Database (universal multi-functional, good)", "Transactional Database Only (server type, focus on transaction processing, general)", "Non-Transactional Database Only (non-transaction type, simple, mainly do some monitoring and counting, support for MyISAM data type is limited to non-transactional), press" Next "to continue.

Select the number of concurrent connections to the site, and the number of simultaneous connections: "Decision Support (DSS) / OLAP (about 20)", "Online Transaction Processing (OLTP) (about 500s)", "Manual Setting (manually set up, enter a number yourself)".

Whether to enable TCP/IP connection, set the port, if not, you can only access the mysql database on your own machine, on this page, you can also select "enable standard mode" (Enable Strict Mode), so that MySQL will not allow minor syntax errors. If you are a novice, it is recommended that you cancel the standard mode to reduce hassle. However, once you are familiar with MySQL, try to use standard mode because it reduces the possibility of harmful data entering the database. Press "Next" to continue.

Is to set the mysql default database language code (important), generally choose UTF-8, press "Next" to continue.

Choose whether to install mysql as a windows service, you can also specify Service Name (service identification name), and whether to add the bin directory of mysql to Windows PATH (after joining, you can directly use the files under bin without indicating the directory name, such as connection, "mysql.exe-uusername-ppassword;", do not point out the full address of mysql.exe, very convenient), I have all checked here, Service Name remains unchanged. Press "Next" to continue.

Ask if you want to change the password of the default root user (Super Admin). "Enable root access from remote machines (whether to allow root users to log in on other machines, if you want security, do not check it, if convenient, check it)." Finally, "Create An Anonymous Account (create an anonymous user, anonymous users can connect to the database, can not manipulate data, including queries)", generally do not need to check, set up, press "Next" to continue.

Confirm that the settings are correct, press "Execute" to make the settings take effect, that is, complete the installation and configuration of MYSQL.

MySQL optimization

Select the most appropriate field attribute to use join instead of subqueries using union instead of manually created temporary tables

Wonderful topic sharing:

Installation tutorials for different versions of mysql

Installation tutorials for each version of mysql5.7

Installation tutorials for each version of mysql5.6

Installation tutorials for each version of mysql8.0

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.