How to install and connect Navicat in MySQL 8.0.20 and what to pay attention to

Things to note

1. First, you need to create a my.ini file in the mysql installation directory with the following content:

[client]
# 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:\\web\\mysql-8.0.11
#Set the storage directory of the MySQL database data. MySQL 8+ does not require the following configuration, the system can generate it by itself, otherwise an error may be reported # datadir=C:\\web\\sqldata
# Maximum number of connections allowed max_connections=20
# 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

2. Configure MySQL environment variables

MYSQL_HOME is the decompression location of MySQL. Add %MYSQL_PATH%\bin to the path.

3. Open cmd as an administrator, cd to the bin directory of mysql, and execute, mysqld --initialize --console . After execution, a temporary database password will appear.

4. Execute the mysql installation command: mysqld install . After successful installation

5. User login: mysql -u root -p , after entering the password, an error message appears: Can't connect to MySQL server on 'localhost' (10061)

6. Restart mysql: net start mysql , and then log in again.

When using navicat to connect to the mysql database, an error will be reported because the password encryption method of mysql8.0 is different from that of the client. At this time, we need to execute the following command

1. Change password to password

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

2. Change the encryption method

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

3. Refresh:

FLUSH PRIVILEGES;

Summarize

This is the end of this article about the methods and precautions for installing mysql8.0.20 and connecting to navicat. For more information about installing mysql8.0.20 and connecting to navicat, please search for previous articles on 123WORDPRESS.COM or continue to browse the related articles below. I hope you will support 123WORDPRESS.COM in the future!