Mysql 5.7.18 installation tutorial and problem summary, mysql5.7.18

Mysql 5.7.18 installation tutorial and problem summary, mysql5.7.18

Mysql 5.7.18 installation and problem summary: A New mysql is deployed today, and several minor problems are encountered. Record the problem.

Step 1: https://dev.mysql.com/downloads/mysql/ download the version to be installed, I'm under windows x64 version

Step 2: Decompress the package to the installation directory./Path/

Step 3: add the environment variable./Path/bin/to the end of the Environment Variable Path, ending ";"

Step 4: Configure my. ini, mainly to set the port, database path, log, buffer, and other configuration information

Step 5: Open the command line window and execute the initialization command

 mysqld –initialize-insecure –user=mysql; mysqld install; net start mysql; mysql; update user set authentication_string=password(“password”) where user='root'; grant usage on *.* to ‘username'@'%' identified by ‘password' with grant option; create database test_db; grant all privileges on test_db.* to ‘username'@'%' identifiedby ‘password'; flush privileges;

Step 6: Enable the firewall port and add inbound rules corresponding to the port

Problem summary:

1. problem: when executing the mysqld command, the system prompts that msvcr120.dll and msvcp120.dll are missing,

Solution:

Download the 32-bit versions of msvcr120.dll, msvcp120.dll, and ucrtbase. dll to the bin directory of mysql. (Khan Yi ...)

2. Problem: An error occurred while executing the mysqld-initialize-insecure-user = mysql command,

Solution: two reasons:

1). No log directory for the corresponding configuration information is created.

2). The data storage directory is not empty.

3. problem: when changing the mysql root password, use the update user set psssword = password ("password") where user = 'root'. The command reports an ERROR: ERROR 1054 (42S22 ): unknown column 'Password' in 'field list'

Solution:

Changed password to "authentication_string"

4. problem: when adding a user, use "insert into mysql. user (host, user, authentication_string) values ("%", "username", password ("password"); "command ERROR: ERROR 1364 (HY000 ): field 'ssl _ cipher 'doesn' t have a default value

Solution:

This is no longer applicable in 5.7. The correct usage is to use the grant usage command.

The above is a summary of mysql 5.7.18 installation tutorials and problems. I hope it will help you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!