Get the App
SLTechnology News&Howtos  ›  Database  › 

Mysql-8.0.16-winx64 installation

Shulou Source: shulou.com Published: 2022-06-01 13:43:45 11月16日 Update

Suggestion [3Grand General]: the command / mysqld.exe cannot be found, but it does exist in the current location. By default, Windows PowerShell does not add from the current location

Carry orders. If you trust this command, type ".\ / mysqld.exe" instead. See "get-help about_Command_Precedence" for more information.

PS D:\ Development\ DataBase\ mysql-8.0.16-winx64\ bin >

PS D:\ Development\ DataBase\ mysql-8.0.16-winx64\ bin >

PS D:\ Development\ DataBase\ mysql-8.0.16-winx64\ bin >

PS D:\ Development\ DataBase\ mysql-8.0.16-winx64\ bin >. / mysqld-- initialize-- console

2019-07-26T13:04:40.868710Z 0 [System] [MY-013169] [Server] D:\ Development\ DataBase\ mysql-8.0.16-winx64\ bin\ mysqld.exe (

Mysqld 8.0.16) initializing of server in progress as process 11000

2019-07-26T13:04:40.875362Z 0 [Warning] [MY-013242] [Server]-- character-set-server: 'utf8' is currently an alias for th

E character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to

Be unambiguous.

2019-07-26T13:05:01.278758Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: KR+jt (_ k

Q1G7

2019-07-26T13:05:08.823938Z 0 [System] [MY-013170] [Server] D:\ Development\ DataBase\ mysql-8.0.16-winx64\ bin\ mysqld.exe (

Mysqld 8.0.16) initializing of server has completed

PS D:\ Development\ DataBase\ mysql-8.0.16-winx64\ bin >

PS D:\ Development\ DataBase\ mysql-8.0.16-winx64\ bin >. / mysqld install

Service successfully installed.

PS D:\ Development\ DataBase\ mysql-8.0.16-winx64\ bin >

PS D:\ Development\ database\ mysql-8.0.16-winx64\ bin >. / mysql- u root-p

Enter password: *

ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

PS D:\ Development\ database\ mysql-8.0.16-winx64\ bin > net start mysql

The MySQL service is starting.

The MySQL service has started successfully.

PS D:\ Development\ database\ mysql-8.0.16-winx64\ bin >. / mysql- u root-p

Enter password: *

Welcome to the MySQL monitor. Commands end with; or\ g.

Your MySQL connection id is 8

Server version: 8.0.16

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

Affiliates. Other names may be trademarks of their respective

Owners.

Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.

Mysql >

Refer to other bloggers' articles to find a solution:

Starting from version 8.0.11, unlike mysql5.7 and previous versions, the default authentication method for setting a user's password is caching_sha2_password. If you find that the original program cannot connect to mysql after upgrading mysql8.0.11, you can quickly set it to mysql5.7 and previous versions of password authentication with the following command on the mysql command line client client. At the same time, the way to change the password under MYSQL8.0.11 is not the same as before. The original partial password change command cannot be used under mysql8.0.11.

Use mysql

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

FLUSH PRIVILEGES

The caching_sha2_password and sha256_password authentication plug-ins provide more secure password encryption than the mysql_native_password plug-in, and caching_sha2_password provides better performance sha256_password. Because of these superior security and performance features, caching_sha2_password is the preferred authentication plug-in for MySQL 8.0, and it is also the default authentication plug-in rather than mysql_native_password. This change will affect the server and libmysqlclient client libraries; currently, it is not compatible with frequently used client software.

Tags: Password command plug-in authentication customer client method version service security location performance identity superiority success not great bad information compatibility at the same time Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno vpn Redmi Docker Huawei OPPO Reno