What to do if initialization of mysql database fails-Mysql Tutorial-php.cn

What to do if initialization of mysql database fails

藏色散人

Release： 2021-07-29 14:13:45

Original

28472 people have browsed it

The solution to the failure to initialize the mysql database: first find and open the my.ini file; then comment out the datadir in the my.ini file; finally follow the prompts to replace UTF8 with UTF8MB4.

What to do if initialization of mysql database fails

# Recommended: "

mysql video tutorial》

Installing MySQL8, the database initialization failed during installation

About the process

Download and extract to the file you want to install For example, the directory this time is directly under the C drive. C:\mysql-8.0.17-winx64
Configure environment variables, add C:\mysql-8.0.17-winx64\bin to the PATH environment variable and note " ;"
Create a new my.ini file in the directory C:\mysql-8.0.17-winx64.
Writing the content of my.ini file, the content is prone to What to do if initialization of mysql database failss
Initialize the database, [I just got stuck here] If the initialization is successful, there may be The default password for MySQL
Installing the database
Start logging in to the database [Use the default password in 5 to log in for the first time]
Change Password

What to do if initialization of mysql database fails I found some tutorials on the Internet as a reference. There is a solution I saw in a comment. Find it. The original blog is no longer available. The solution is as shown below, which is to comment out the datadir line.

The main problem encountered is that when writing the my.ini file, there may be What to do if initialization of mysql database failss in format and content. Pay attention to the format and try "\", "\" and "/". , and **"C:\mysql-8.0.17-winx64"** also try whether to add double quotes. The following is my my.ini file. The general content is the same as the reference blog. The marked locations are some of the changes I made after reporting the What to do if initialization of mysql database fails.

The What to do if initialization of mysql database fails reported on the command line during database initialization is as follows:

C:\mysql-8.0.17-winx64\bin>mysqld --initialize --console
2019-08-24T13:33:22.622321Z 0 [System] [MY-013169] [Server] C:\mysql-8.0.17-winx64\bin\mysqld.exe (mysqld 8.0.17) initializing of server in progress as process 8404
2019-08-24T13:33:22.624188Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.
2019-08-24T13:33:22.625619Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting.
2019-08-24T13:33:22.625635Z 0 [ERROR] [MY-013236] [Server] The designated data directory C:\mysql-8.0.17-winx64\data\ is unusable. You can remove all files that the server added to it.
2019-08-24T13:33:22.643590Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-08-24T13:33:22.643744Z 0 [System] [MY-010910] [Server] C:\mysql-8.0.17-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.17)  MySQL Community Server - GPL.

Copy after login

What to do if initialization of mysql database fails

The problem should be the problem with the data folder. At that time, there was no newly generated data folder in the C:\mysql-8.0.17-winx64 directory.

Comment out the datadir line in the my.ini file. The What to do if initialization of mysql database fails was gone and the data folder was gone. Appears, as shown below: The solution to the
warring is to replace
UTF8 with UTF8MB4 according to the prompts. Changes are marked in the figure above.

2019-08-24T13:33:22.624188Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.

Copy after login

Finally initialized successfully, as shown in the figure:

What to do if initialization of mysql database fails Overall process

C:\mysql-8.0.17-winx64\bin>mysqld --initialize --console
2019-08-24T13:37:11.590803Z 0 [System] [MY-013169] [Server] C:\mysql-8.0.17-winx64\bin\mysqld.exe (mysqld 8.0.17) initializing of server in progress as process 2484
2019-08-24T13:37:15.862830Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 37swG%65Qjf1
2019-08-24T13:37:17.783854Z 0 [System] [MY-013170] [Server] C:\mysql-8.0.17-winx64\bin\mysqld.exe (mysqld 8.0.17) initializing of server has completed

C:\mysql-8.0.17-winx64\bin>mysqld --install
The service already exists!
The current server installed: C:\mysql-8.0.17-winx64\bin\mysqld.exe MySQL

C:\mysql-8.0.17-winx64\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。


C:\mysql-8.0.17-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.17

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 &#39;help;&#39; or &#39;\h&#39; for help. Type &#39;\c&#39; to clear the current input statement.

mysql> ALTER USER &#39;root&#39;@&#39;localhost&#39; IDENTIFIED WITH mysql_native_password BY &#39;111111&#39;;
Query OK, 0 rows affected (0.01 sec)

mysql>

Copy after login

The above is the detailed content of What to do if initialization of mysql database fails. For more information, please follow other related articles on the PHP Chinese website!