Mysql 8.0 installation and password reset issues

Mysql 8.0 installation problems and password reset

1: Download MySql

Official website download address: https://dev.mysql.com/downloads/mysql/

2: Install MySql

Open the downloaded file and unzip it to the specified directory.

Open the unzipped MySql file and create my.ini (mysql configuration file) in the root directory. Use nodpad++c to create

Here you need to change the basedir and datadir paths to the mysql decompression path

[mysql]
# Set the default character set of the mysql client to default-character-set=utf8
[mysqld]
#Set port 3306 port = 3306
# Set the installation directory of mysql basedir=C:\Program Files\Java\mysql-8.0.12-winx64\mysql-8.0.12-winx64
# Set the storage directory of mysql database data datadir=C:\Program Files\Java\mysql-8.0.12-winx64\mysql-8.0.12-winx64\datadir
# Maximum number of connections allowed max_connections=200
# The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB
skip-grant-tables

Find the CMD command prompt

Enter the mysql subdirectory bin

Enter in sequence: mysqld --install (install)

mysqld --initialize (Initialization)
net start mysql (run) 

I have completed the installation here. This machine is Apple Windows 7 and has only one C drive, so it can only be installed in the C path.

3: Change password

Because the latest version of MySQL 8.0 is downloaded, it comes with a password and must be reset when used.

Use administrator privileges to enter mysql, the system requires a password.

The original password is in the .err file in C:\Program Files\Java\mysql-8.0.12-winx64\mysql-8.0.12-winx64\data.

Open .err, the password is on this line of the file.

Type the password into enter password in cmd.

Testing will report an error

Insert command to change password

alter user 'root'@'localhost' identified with mysql_native_password by 'your password';

Prompt Query OK

Test using database:

Note that the database statement must end with a semicolon, otherwise it will not be executed and -> will appear continuously.

Summarize

The above is the MySQL 8.0 installation and password reset issues introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time!