the reason
It appears in the mysql error log: The innodb_system data file’ibdata1′ must be writable, literally: ibdata1 must be writable
Check the log and report an error, the folder has no write permission
cat /var/log/mysqld.log
solve
Find file path
find / -name ibdata1
Grant folder permissions
chmod -R 777 /var/lib/mysql
chown mysql:mysql -R /var/lib/mysql
Start MySQL
systemctl start mysqld.service
// CHECK MySQL STATUS
systemctl status mysqld.service
Read More:
- How to Solve can‘t connect to local mysql server through socket ‘/var/lib/mysql/mysql.sock‘
- Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
- [Solved] ERROR 2002 (HY000): Can’t connect to local MySQL server through socket’/var/lib/mysql/mysql.sock’ (2)
- How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
- MySql Install Error: Can‘t connect to local MySQL server through socket ‘/tmp/mysql.sock‘
- [Solved] MYSQL Command Execute Error: Can ‘t connect to local MySQL server through socket ‘/tmp/mysql.sock ‘(2) “
- Mysql Flashback Warning: C:\Program Files\MySQL\MySQL Server 8.0\bin\mysql.exe
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’
- MYSQL Enter password:ERROR 2003 (HY000): Can‘t connect to MySQL server on ‘localhost:3306‘
- MYSQL Insert Data Error: check the manual that corresponds to your MySQL server version for the right syntax
- How to Solve MYSQL into outfile Error13
- (Fixed) workbench MySQL Error Code: 2013. Lost connection to MySQL server during query
- How to Solve Mysql8 load data error
- MAC MYSQL Start Error: The server quit without updating PID
- [Solved] com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
- MYSQL 5.7 Error Code: 1290. The MySQL server is running with the –secure-file-priv option so it..
- How to Solve mysql [Err] 1067-Invalid default value for
- IDEA maven Config MYSQL Connection Error: Could not create connection to database server.
- host ‘‘ is not allowed to connect to this mysql server Connect MYSQL Error
- [Solved] MYSQL Error: ERROR! MySQL server PID file could not be found!