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

This article mainly introduces the "mysql8.0.27 configuration methods and what matters needing attention" related knowledge, the editor through the actual case to show you the operation process, the operation method is simple and fast, practical, I hope that this "mysql8.0.27 configuration methods and what matters needing attention" article can help you solve the problem.

Choose this.

Download the first one directly and notice whether we need 64 or 32

Click here to start downloading

Installation configuration unzipped installation package

The d disk I unzipped here

open

Write MySQL configuration file

Create a new my.ini file in the decompressed directory

Copy the following text into the my,ini file / / Note that the file path is the address to which you extracted it.

[mysqld] # set port 3306 port=3306# set mysql installation directory-is your file path-basedir=D:\ mysql-8.0.26-winx64\ mysql-8.0.26-winx64# set mysql database data storage directory-is your file path data folder create # datadir=E:\ Maximum number of connections allowed by mysql\ mysql\ data# the number of failed connections allowed by max_connections=200#. The character set used by the max_connect_errors=10# server defaults to the default storage engine that utf8mb4character-set-server=utf8mb4# will use when creating a new table. Default-storage-engine=INNODB# defaults to use the "mysql_native_password" plug-in authentication # mysql_native_passworddefault_authentication_plugin=mysql_native_ password [MySQL] # to set the default character set default-character-set=utf8mb4 [client] # for the mysql client to connect to the server. Port port=3306default-character-set=utf8mb4 text link: https://blog.csdn.net/a802976/article/details/119255644 initializes MySQL database

Open the command prompt as an administrator

Change to the bin directory

Beginners should use cd to open it.

Execute the command under the bin directory under the MySQL directory:

Mysqld-initialize-console

If there is no explicit random code and what ends with g, it means that you can't find a valid directory in the data file. You need to delete the data directory and then extract the directory again. It will create a data directory of its own (the data directory is best not created by hand).

My random password is: 2 (eE8rwv#a (?

Install the mysql service and start mysqld-- initialize-- console

If it appears like this, you are not running cmd as an administrator

The correct one is

All subsequent operations have to be performed as an administrator.

Net start mysql

Mysql-uroot-p

Enter the random code just now

Modify the password

ALTER USER 'root'@'localhost' IDENTIFIED BY' password you want to change'

The password here is set to 111111.

Later, when you run the software, it will report an error of ching_sha2_password, and then don't panic. It tells you that the encryption rule of mysql8 was mysql_native_password and now it is ching_sha2_password.

There are two ways to solve the problem, one is to upgrade the navicat driver, the other is to restore the mysql user login password encryption rules to mysql_native_password.

In the second way, the solution is as follows

1. Administrator privileges to run the command prompt

Log in to MySQL (remember to add environment variables)

Mysql-u root-p

Password:

. Modify account password encryption rules and update user password

ALTER USER 'root'@'localhost' IDENTIFIED BY' password' PASSWORD EXPIRE NEVER; # modify the encryption rules ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' password'; # update the user's password

Reset password command alone: alter user 'root'@'localhost' identified by' the password you want to set'

Now open Navicat Premium 12 to connect to the MySQL problem database again and you will find that the connection can be successful.

This is the end of the content about "the method of mysql8.0.27 configuration and what matters needing attention". Thank you for your reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

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.