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

This article gives you an example to share the specific steps of windows10 changing mysql8.0.17 for your reference. The details are as follows.

Download windows version of mysql

Create my.ini file after decompression initialize mysql and data folders to store data

My.ini content

[mysqld] # set port 3306 port=3306# set the installation directory of mysql:\ javaDevlepTool\ mysql\ mysql-windows-service\ mysql-8.0.17-winx64# set the directory where the data of the mysql database is stored datadir=D:\ javaDevlepTool\ mysql\ mysql-windows-service\ mysql-8.0.17-winx64\ data# the maximum number of connections max_connections=200# allows the number of connections to fail. This is to prevent anyone from attempting to attack the character set used by the max_connect_errors=10# server of the database system from this host. By default, the default storage engine default-storage-engine=INNODB [mysql] # to be used by UTF8character-set-server=utf8# to create a new table sets the mysql client's default character set default-character-set=utf8 [client] # to set the default port port=3306default-character-set=utf8 when the mysql client connects to the server.

Then configure the environment variable to point to the directory

Open the cmd window as an administrator and jump to E:\ mysql-8.0.11-winx64\ bin (just hold down the shift key and right-click in this directory and open the powershell window here)

Initialization command:.\ mysqld-- initialize-- user=mysql-- console will initialize mysql and generate a temporary password, remember

Then type mysqld-install to add the service.

Net start mysql Startup Service

Log in with a temporary password

Change the password: ALTER USER root@localhost IDENTIFIED BY '123456; change the password to: 123456

An error is reported with sqlyog connection at this time: error 2058 plugin caching sha2_password could not be loaded

ALTER USER'root'@'localhost' IDENTIFIED BY 'root' PASSWORD EXPIRE NEVER; # modify the encryption rule ALTER USER'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' 123456update the user's password FLUSH PRIVILEGES; # refresh permission

Connect again, connected successfully

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.