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

1. Download and decompress the official website.

Https://dev.mysql.com/downloads/mysql/

2. Set environment variables

Configure MYSQL_HOME as the decompression path of MySQL and set it in path;% MYSQL_HOME%\ bin

3. Under the MySQL decompression path, create new my.ini configuration initialization parameters:

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 3306 # set mysql installation directory basedir=D:\ Java\ mysql-8.0.15-winx64# set mysql database data storage directory datadir=D:\ Java\ mysql-8.0.15-winx64\ data# maximum number of connections the character set used by the max_connections=200# server defaults to 8-bit encoding The default storage engine default-storage-engine=INNODB that the latin1 character set character-set-server=utf8# will use when creating new tables

4. Initialize the database

Open the cmd command window as an administrator, and enter the mysqld-- initialize command to initialize the data data directory of mysql. After initialization, a data folder will be generated under the decompressed directory, under which there will be a file ending with .err, and a randomly generated password will be generated when opened.

5. Install the service

# Registration Service mysqld-- install# launches Service net start mysql

6. Change the password

ALTER USER USER () IDENTIFIED BY 'new password'

Log in successfully with the new password, finished!

Problems in installation

1. The service name is invalid

The cause of the problem: mysql is not registered with the service in the system, that is, there is no mysql service under the current path.

Problem solved: enter mysqld-- install on the command line, and Service successfully install indicates that the installation is successful

2. Login is allowed in cmd, but not in Navicat.

Hint: 1251-Client does not support authentication protocol requested by server; consider upgrading MySQL client

Cause of the problem: in previous versions of mysql8, the encryption rule was mysql_native_password, while after mysql8, the encryption rule was caching_sha2_password.

Problem solving: restore the mysql login password encryption rules to mysql_native_password, or upgrade the Navicat driver

# update the user's password rules ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' password'; # refresh permission FLUSH PRIVILEGES

[with tips]

Quick access to administrator cmd

There are three ways to supplement mysql exit:

Mysql > exit

Mysql > quit

Mysql >\ Q

Summary

The above is a detailed description of the installation tutorial of the mysql-8.0.15-winx64 decompressed version introduced by the editor. I hope it will be helpful to you. If you have any questions, you are welcome to leave a message. The editor will reply to you in time!

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.