MySQL installation

There are a few key things to note, and everything else is just default

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

Mysql > select UTF-8 and press “Next” to continue.

Mysql > install mysql as a Windows Service, you can also specify Service Name (Service id Name), whether to add mysql to the bin directory of Windows PATH, you can directly use the file under bin without specifying the directory Name, such as connection. “Mysql. Exe – uusername – ppassword;” Mysql > select mysql.exe from mysql.exe. Mysql > select mysql.exe from mysql.exe. Press “Next” to continue.

Asks if you want to change the password of the default root user (super admin). Enable root access from remote machines Enable root access from remote machines Finally, “Create An Anonymous Account (Create An Anonymous Account, Anonymous user can connect to the database, can not operate data, including query)”, generally do not check box, after setting, press “Next” to continue.

Confirm the Settings and press Execute to make the Settings take effect. That is, the MYSQL installation and configuration are complete.

Note: A common error occurs when you press “Finish” to Start the mysql server. This error occurs when you install mysql on the server where it was installed. If not, check whether according to the above step, the previous password has been changed, according to the above operation; If still not, will the mysql installation directory data backup folder, and then deleted, after the installation is complete, will be installed to generate the data folder to delete, backup the data folder, and then restart the mysql service is ok, in this case, may need to check the database, and then repair time, prevent data error.

\

Proof that it has been installed

Go to Start – CMD – enter: mysql -u root -p- Press Enter -root

-u indicates the server name. -p Indicates the password. The Mysql installation is complete.

The last step: configure the environment variables for future convenience

Go to My Computer – Properties – Select Advanced Properties – Environment Variables – Path

Connect to Navicat visual interface