BUG集合——MYSQL 服务无法启动

MYSQL 服务无法启动

Microsoft Windows [版本 10.0.22000.593]
(c) Microsoft Corporation。保留所有权利。

C:\Users\30628>cd D:
D:\

C:\Users\30628>D:

D:\>cd D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin

D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysqld --remove mysql57
Service successfully removed.

D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysqld --install mysql157 --defaults-file=D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin\my.ini

D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>net start mysql157
服务名无效。

请键入 NET HELPMSG 2185 以获得更多的帮助。


D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysqld --install mysql157 --defaults-file=D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin\my.ini

D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>net start mysql157
服务名无效。

请键入 NET HELPMSG 2185 以获得更多的帮助。


D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysqld --install mysql157 --defaults-file=D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin\my.ini

D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysqld --initialize --user=mysql --console
2022-04-13T03:07:37.656779Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2022-04-13T03:07:37.656828Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2022-04-13T03:07:37.659177Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
2022-04-13T03:07:37.659593Z 0 [ERROR] Aborting


D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysqld --initialize --user=mysql --console
2022-04-13T03:08:16.133523Z 0 [Warning] InnoDB: New log files created, LSN=45790
2022-04-13T03:08:16.244651Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2022-04-13T03:08:16.351163Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: f687c445-bad6-11ec-a710-98e7432a5d61.
2022-04-13T03:08:16.357682Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-04-13T03:08:17.225058Z 0 [Warning] CA certificate ca.pem is self signed.
2022-04-13T03:08:17.772838Z 1 [Note] A temporary password is generated for root@localhost: lfG/6EXtKyii

D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysqld --install mysql157 --defaults-file=D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin\my.ini

D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>net start mysql157
服务名无效。

请键入 NET HELPMSG 2185 以获得更多的帮助。


D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysqld --initialize --user=mysql --console
2022-04-13T03:12:29.269278Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-04-13T03:12:29.632649Z 0 [Warning] InnoDB: New log files created, LSN=45790
2022-04-13T03:12:29.700192Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2022-04-13T03:12:29.784215Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 8d968edf-bad7-11ec-bad5-98e7432a5d61.
2022-04-13T03:12:29.791064Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-04-13T03:12:31.564032Z 0 [Warning] CA certificate ca.pem is self signed.
2022-04-13T03:12:32.132037Z 1 [Note] A temporary password is generated for root@localhost: ?w2(,uKEgez(

D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysqld --install mysql157 --defaults-file=D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin\my.ini

D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>net start mysql157
服务名无效。

请键入 NET HELPMSG 2185 以获得更多的帮助。


D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysqld install
Service successfully installed.

D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysqld –initialize
mysqld: Can't change dir to 'D:\Program Files (x86)\MySQL\MySQL Server 5.7\data\' (Errcode: 2 - No such file or directory)
2022-04-13T03:17:21.092531Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-04-13T03:17:21.092596Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2022-04-13T03:17:21.093399Z 0 [Note] mysqld (mysqld 5.7.30) starting as process 1552 ...
2022-04-13T03:17:21.096138Z 0 [Warning] Can't create test file D:\Program Files (x86)\MySQL\MySQL Server 5.7\data\愿青春不负梦想.lower-test
2022-04-13T03:17:21.096605Z 0 [Warning] Can't create test file D:\Program Files (x86)\MySQL\MySQL Server 5.7\data\愿青春不负梦想.lower-test
2022-04-13T03:17:21.097553Z 0 [ERROR] failed to set datadir to D:\Program Files (x86)\MySQL\MySQL Server 5.7\data\
2022-04-13T03:17:21.098038Z 0 [ERROR] Aborting

2022-04-13T03:17:21.098238Z 0 [Note] Binlog end
2022-04-13T03:17:21.098606Z 0 [Note] mysqld: Shutdown complete


D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务无法启动。

服务没有报告任何错误。

请键入 NET HELPMSG 3534 以获得更多的帮助。


D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务无法启动。

服务没有报告任何错误。

请键入 NET HELPMSG 3534 以获得更多的帮助。


D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>winmysqladmin
'winmysqladmin' 不是内部或外部命令，也不是可运行的程序
或批处理文件。

D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysqld --initialize-insecure

D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysqld install
The service already exists!
The current server installed: "D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin\mysqld" MySQL

D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。


D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>
D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysql -u -p password
ERROR 1045 (28000): Access denied for user '-p'@'localhost' (using password: NO)

D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysql -u -p password
ERROR 1045 (28000): Access denied for user '-p'@'localhost' (using password: NO)

D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.7.30 MySQL Community Server (GPL)

Copyright (c) 2000, 2020, 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> -u root
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-u root' at line 1
mysql> -p password
    ->
    ->
    ->
    ->
    ->
    ->
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-p password' at line 1
mysql> exit
Bye

D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysqladmin -u root -p password
Enter password: ****
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>mysqladmin -u root -p password
Enter password: ****
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

D:\Program Files (x86)\MySQL\MySQL Server 5.7\bin>