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

1. Download the package and decompress it to the target location

2. Create a new my.ini file under bin (only for versions without default configuration files)

# Code start

[Client]

# set port 3306

Port=3306

[mysqld]

# set port 3306

Port=3306

# set the installation directory of mysql

Basedir=C:\ Program Files\ MYSQL\ mysql-5.7.19-winx64

# set the storage directory of the data in the mysql database

Datadir=C:\ Program Files\ MYSQL\ mysql-5.7.19-winx64\ data

# maximum number of connections allowed

Max_connections=200

# the character set used by the server defaults to the 8-bit coded latin1 character set

Character-set-server=utf8

# default storage engine to be used when creating new tables

Default-storage-engine=INNODB

Sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysql]

# set mysql client default character set

Default-character-set=utf8

# Code end

3. Create a new data folder

4. Configure environment variables: add a bin directory under path, such as: C:\ Program Files\ MYSQL\ mysql-5.7.19-winx64\ bin

5. Cmd/ runs as an administrator

6 、

Enter cd G:\ Program Files\ MySQL\ MySQL Server 5.7\ bin to enter the bin directory

Enter mysqld-initialize-user=mysql-console

Write down the random password generated by the last line

For example: 2017-07-28T10:02:03.149629Z 1 [Note] A temporary password is generated for root@localhost:% i:Vmba=S8u5

Password:% i:Vmba=S8u5

Then enter mysqld-- install will display Servers Successfully installed after success

Enter net start mysql under the console to start the mysql service

7. Use the mysql-uroot-p command to log in to the database. The password is randomly generated.

Note: the password must be changed immediately after login, otherwise the command cannot be executed.

Change the password: SET PASSWORD = PASSWORD ('new_password')

It can be used normally at this time.

-refer to many network materials for successful installation, and summarize this article, if it is helpful to reprint it at will

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.