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

This article introduces the knowledge of "how to install and configure Mysql8.0". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

1. Download the mysql package directly from the official website to install it, and extract it to the installation directory.

2. Configure environment variables: configure the bin path of mysql to the environment variable path

3. In the control console, go to the bin directory of the MySQL you just extracted:

4. Initialize the MySQL database

Enter mysqld-- initialize-insecure

After the initialization is completed, the data folder is automatically generated in the mysql root directory, as shown in the following figure, which indicates that the initialization is successful.

5. Install MySQL service for Windows system

Command: mysqld install

Purpose: install the MySQL service for the Windows system. The default service name is mysql

(note: if you want to delete the MySQL service, you can use the command "mysqld remove"

However, before deleting the MySQL service, you need to make sure that the MySQL service is stopped.)

6. Start the service

Command: net start mysql

If you want to stop the MySQL service, you can use the command "net stop mysql"

The MySQL service cannot be deleted until the MySQL service is stopped.)

7. Log in to the database

Under the bin path, enter mysql-uroot-p, press enter and press enter again directly.

(after the initial installation, the default password is empty, press enter to log in to the database)

8. Change the password

Enter the mysql statement: ALTER USER 'root'@'localhost' IDENTIFIED BY' 123456'

9. There may be an error logging in navicat for mysql: 1251-Client does not support authentication protocol error occurred in Navicat for MySQL connection Mysql 8.0.11

(1) Open the small black screen on the command line, enter the bin directory of MySQL, and then enter the mysql-u root-p password

(2) ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' password'

(3) FLUSH PRIVILEGES; # refresh permissions

After the operation, you can test the user on the navicat client connection.

This is the end of "how to install and configure Mysql8.0". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.