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

D:\ mysql-8.0.15-winx64\ bin > mysqld-- defaults-file=D:\ mysql-8.0.15-winx64\ my.ini-- initialize-- console2019-03-16T06:11:12.538350Z 0 [System] [MY-013169] [Server] D:\ mysql-8.0.15-winx64\ bin\ mysqld.exe (mysqld 8.0.15) initializing of server in progress as process 111362019-03-16T06:11:32.301846Z 5 [Note] [MY-010454] [ Server] A temporary password is generated for root@localhost: K) gt#U*D8b A2019-03-16T06:11:41.101367Z 0 [System] [MY-013170] [Server] D:\ mysql-8.0.15-winx64\ bin\ mysqld.exe (mysqld 8.0.15) initializing of server has completed prompt:

Navicat connection mysql display Clinet dose not support authentication protocol request by server

1 enter mysql-uroot-p in the command window first enter mysql 2 via cmd to change the encryption method mysql > ALTER USER 'root'@'localhost' IDENTIFIED BY' password' PASSWORD EXPIRE NEVER;Query OK, 0 rows affected (0.10 sec) 3 change password mysql > ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY' 123 query OK, 0 rows affected (0.35 sec) this password is the password of navicat link mysql 4 refresh mysql > FLUSH PRIVILEGES;Query OK, 0 rows affected (0.28 sec)

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.