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

Win10 installs the decompressed version of mysql5.7 for your reference. The details are as follows

@ (environment configuration)

Introduction

I have been using the install version of mysql before, but I always feel that there are too many things to start, so I would like to try the decompressed version. There are a lot of problems encountered in the installation process, write down some pits.

download

Of course, the official website of mysql will download it yourself:

Address: http://dev.mysql.com/downloads/mysql/

Download is a compressed package, decompress directly use, my decompression directory here is: d:\ greenware\ mysql57, this is mysql_root.

Installation

Extract the directory:

Pay attention to two things:

1. The data folder and my.ini are not available for the first time. The data folder can be initialized automatically by the mysql tool, so don't create it yourself.

two。 Create your own my.ini content:

[mysql] default-character-set= UTF8 [mysqld] port = 3306basedir = D:\ greenware\ mysql57datadir = D:\ greenware\ mysql57\ datamax_connections=200character-set-server=utf8default-storage-engine=INNODB

Then we begin to install:

Open the administrator permissions command line under mysql_root\ bin

Execute: mysqld-- install

Execution: mysqld-- initialize, you need to wait a little while. To finish without mistakes is success. After success, you can see that the data folder is generated under mysql_root

Execute net start mysql to start the service, and if the prompt is successful, the installation is completely correct.

Set the initial password

The default root password after mysql 5.7is not empty, so here we need to set it ourselves.

First of all, turn off the service that has just started, and you can net stop mysql or stop it yourself in the service. Then execute it in the mysql_root\ bin directory: mysqld-- defaults-file= "D:\ greenware\ mysql57\ my.ini"-- console-- skip-grant-tables, where the configuration file is the directory we just added. Then it will output a lot of things, and finally, please don't close the console.

Launch another console and execute: mysql-u root-p. You don't need to enter password, and you can enter it directly:

Then set the root password, and execute it in turn to set the root password.

Use mysql;update user set authentication_string=password (new password) where user= "root"; flush privileges

Error: You must reset your password using ALTER USER statement before executing thi …

Completing the above steps should be successful, but if you encounter this error the next time you come in:

You must reset your password using ALTER USER statement before executing thi...

Solution:

Step 1: SET PASSWORD = PASSWORD ('your new password')

Step 2: ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER

Step 3: flush privileges

It's over!

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.