My error report is like the following picture
The prompt is as follows: an error is reported
2021-12-26T12:28:24.321789Z 0 [System] [MY-010116] [Server] C:\mysql-8.0.26-winx64\bin\mysqld.exe (mysqld 8.0.26) starting as process 8168
2021-12-26T12:28:24.323688Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2021-12-26T12:28:24.335659Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2021-12-26T12:28:24.337392Z 1 [ERROR] [MY-012271] [InnoDB] The innodb_system data file 'ibdata1' must be writable
2021-12-26T12:28:24.337508Z 1 [ERROR] [MY-012278] [InnoDB] The innodb_system data file 'ibdata1' must be writable
2021-12-26T12:28:24.337618Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2021-12-26T12:28:24.337878Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2021-12-26T12:28:24.337978Z 0 [ERROR] [MY-010119] [Server] Aborting
2021-12-26T12:28:24.338395Z 0 [System] [MY-010910] [Server] C:\mysql-8.0.26-winx64\bin\mysqld.exe: Shutdown complete (mysqld 8.0.26) MySQL Community Server - GPL.
Reason guess:
The MySQL service is always turned on (it starts automatically after startup), so when it is turned on, an error will be reported when the command line is started
Solution:
Enter the command prompt in administrator mode and enter the following command to close the MySQL service
net stop mysql
So far, the problem has been solved. Entering mysqld — console again will open the MySQL service normally
Read More:
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’
- How to Solve MYSQL Error: Failed to start MySQL 8.0 database server
- ERROR: mysqld failed while attempting to check config [How to Solve]
- [Solved] Job for mysqld.service failed because the control process exited with error code
- [Solved] MySQL Startup Error: Job for mysqld.service failed because the control process exited with error code
- [ERROR] InnoDB: The error means mysqld does not have the access rights to the directory.
- MYSQL8 Startup Error: mysqld_safe error: log-error set to ‘/var/log/mariadb/mariadb.log‘
- How to Solve Mysql8 load data error
- How to Solve mysql [Err] 1067-Invalid default value for
- Docker: How to Solve MYSQL8 & Navicat remote connection error
- Centos7 Initialize mysql Error: Could not open file ‘/usr/local/mysql/log/mysqld.log‘ for error logging: Per
- How to Solve Nacos startup error
- How to Solve Azkaban startup error
- How to Solve MYSQL Error: No module named MySQLdb
- How to Solve MySQL version 5.7+ Group by group error
- How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
- How to Solve Error: Rsa Public Key not Find
- How to Solve MYSQL into outfile Error13
- How to Solve Embulk Error: OutputPlugin’bigquery’ is not found
- How to Solve c3p0 connect mysql8.0 Error