MySQL 8.0.11 installation and configuration method graphic tutorial (win10)

This article records the installation and configuration methods of MySQL 8.0.11 for your reference. The specific contents are as follows

1. MySQL Installation

1.1 Download the Windows version of MySQL installation package from the MySQL official website

Download

After clicking Download, the following interface will pop up. Click No thanks, just start my download

1.2 After downloading, unzip the zip package to the directory you want to install it. I put the unzipped folder under D:\MySQL.

1.3 Configure environment variables:

Go to Computer – Advanced System Settings – Advanced – Environment Variables and add the path where MySQL is unzipped

1.4 Next, configure the MySQL configuration file

Open the folder D:\MySQL\mysql-8.0.11-winx64 that you just unzipped, create a configuration file called my.ini, edit my.ini and configure the following basic information:

[mysql]
default-character-set=utf8

[mysqld]
port = 3306
basedir=D:\MySQL\mysql-8.0.11-winx64
datadir=D:\MySQL\mysql-8.0.11-winx64\data
character-set-server=utf8
default-storage-engine=INNODB

Next, let's start the MySQL database:
Open the cmd command line tool as an administrator and switch directories:

D:
cd D:\MySQL\mysql-8.0.11-winx64\bin

Enter the initialization command:

mysqld --initialize-insecure --user=mysql

Generate the data directory in the D:\MySQL\mysql-8.0.11-winx64\bin directory

To start, enter the following command:

net start mysql 

This proves that the connection has been successful.

If an error occurs that prevents you from starting, as follows:

The reason may be that you have opened other databases and the port is occupied. First open Control Panel - System Security - Administrative Tools

The management tool interface pops up, click Service

The service page pops up, as shown in the figure

You can see that MySQL80 is started, but mysql is not started. MySQL80 is a network service MySQL database installed through the MySQL installer client. Local and network are not enabled at the same time.

When you want to use the locally created MySQL, you should first close the MySQL80 network service database. There are two ways to close it:
1) Right-click MySQL80 and click Stop
2) Enter the following command in the command terminal:

net stop MySQL80 

Then enter

net start mysql

It can start normally.

2. Reset MySQL password

2.1 Log in to MySQL

enter:

mysql -u root -p

Because no password was set before, the password is empty, just press Enter:

2.2 Query user password:

Query user password command:

mysql> select host,user,authentication_string from mysql.user;

Host: The IP address that allows the user to log in;
user: the user name of the current database;
authentication_string： user password;
If empty, the root line should be empty.

2.3 Set (or modify) the root user password:

Note: The password field and password() function are deprecated in MySQL 5.7.9 and later.

Do not use the following forms for your password:

use mysql; 
update user set authentication_string="newpassword" where user="root";

This will set the newpassword value under the authentication_string field of the root user in the user table;

The correct steps to change the root password are:

1) If there is content under the authentication_string field of the current root user, set it to empty first. If not, skip to step 2).

use mysql; 
update user set authentication_string='' where user='root'

2) Use ALTER to modify the root user password. The method is:

use mysql;
ALTER user 'root'@'localhost' IDENTIFIED BY 'new password';
FLUSH PRIVILEGES;

So far, the local MySQL you created has been created! ! !
Just reconnect! ! ! !

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.7 installation tutorials for various versions

MySQL 5.6 installation tutorials for various versions

mysql8.0 installation tutorials for various versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.