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

This article mainly explains how to install and connect mysql8.0.20 navicat, the content is clear, interested friends can learn, I believe that after reading it will be helpful.

What you need to pay attention to.

1. First, you need to create a new my.ini file under the installation directory of mysql, as follows:

[client] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 330 set mysql installation directory basedir=C:\\ web\\ mysql-8.0.11# set mysql database data storage directory, MySQL 8 + does not need the following configuration, the system can generate its own Otherwise, there may be an error # datadir=C:\\ web\\ sqldata# allows maximum number of connections the character set used by the max_connections=20# server defaults to the 8-bit encoded latin1 character set character-set-server=utf8# the default storage engine default-storage-engine=INNODB that will be used when creating new tables

two。 Configure the environment variables for mysql

MYSQL_HOME is the unzipped location of mysql, add% MYSQL_PATH%\ bin to the path path

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

4. Execute the install mysql command: mysqld install, after the installation is successful

5. User login: mysql-u root-p, enter the password and report an error, Can't connect to MySQL server on 'localhost' (10061)

6. Restart mysql:net start mysql and the user can log in again.

There will be an error when using navicat to connect to the mysql database, because the password encryption of mysql8.0 is different from that of the client, so we need to execute the following command

1. Change the password to password

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

two。 Change the encryption method

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

3. Refresh:

After reading the above content, FLUSH PRIVILEGES; has a further understanding of how mysql8.0.20 installs and connects navicat. If you want to learn more, you are welcome to follow the industry information channel.

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.