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

This article mainly introduces how to install MYSQL5.7.24 under Windows Server 2012, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to know about it.

1. Prepare the .zip free installation package for the database and download the address.

Link: https://pan.baidu.com/s/1vI6W-F7XZ0iKuCMSBtUuhQ?pwd=r9p1

Extraction code: r9p1

two。 Extract it to where you want to install it.

3. Configure environment variables

Right-click this computer-> Properties-> Advanced system Settings-> Environment variables

Create a new MYSQL_HOME in the system variable

The variable value here is the unzipped address of MYSQL.

At the same time, find path in the system variable, edit, and add% MYSQL_HOME%\ bin after it

4. Create a new my.ini profile [mysql] default-character-set=utf8 [mysqld] character-set-server=utf8default-storage-engine=INNODBsql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTIONmax_connect_errors=10max_connections=50

Put it in the installation directory

5. Enter mysqld-- initialize-insecure in cmd (administrator)

If there is no error message (as shown below), it proves that there is no problem with the initialization of the data directory. At this point, check that the data directory has been generated under the MySQL directory.

6. Enter mysqld-install to install the MYSQL service

Service installed successfully

7. Start and shut down service net start mysql / / start mysql service net stop mysql / / stop mysql service 8. Change the account password and log in to mysqladmin-uyouruser password yourpassword / / change the default account password mysql-uyouruser-pyourpassword / / Thank you for reading this article carefully. I hope the article "how to install MYSQL5.7.24 under Windows Server 2012" shared by the editor will be helpful to you. At the same time, I also hope you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.