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

This article will explain in detail how to install Mysql5.7 in Windows Server 2008. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Today we install and configure Mysql5.7 under windows server 2008

1. Download Mysql5.7

Address: https://dev.mysql.com/downloads/mysql/5.7.html

No need to log in, download directly

two。 Install and configure Mysql

Extract the downloaded file and copy it to the c:\ root directory and name it mysql-5.7

Enter the mysql-5.7 directory and create a new my.ini file as follows

[mysqld] # Port number port = 330 paths basedir=c:\ mysql-5.7# database file path datadir=c:\ mysql-5.7\ data # maximum number of connections max_connections=200# Encoding character-set-server=utf8default-storage-engine=INNODBsql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_ tables [MySQL] # Encoding default-character-set=utf8

Set environment variabl

3. Install the Mysql service

Open a command prompt as an administrator and enter the bin directory of mysql, as follows:

Enter the msyql service installation command

Mysqld-install

Seeing the above information indicates that the service has been installed successfully

Initialize by entering the following command

Mysqld-initialize

Start the service

Net start mysql

4. test

Enter mysql-h227.0.0.1-uroot-p

We need a password. We have to change root's password.

Add a row to the my.ini

Skip_grant_tables

Restart mysql

Net stop mysqlnet start mysql

If you test again, enter directly and you can enter.

Execute a sql statement to change the administrator's password to root

Use mysql;UPDATE user SET authentication_string=password ("root") WHERE user= "root"

Use root for login password after removing skip_grant_tables from my.ini

Mysql-h 127.0.0.1-u root-p root

At this point, mysql5.7 installation is complete.

About Windows Server 2008 how to install Mysql5.7 to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.