剛安裝的mysql無法啟動豆村，提示沒有權(quán)限
The innodb_system data file 'ibdata1' must be writable
[root@localhost ~]# mysqld --initialize
[root@localhost ~]# systemctl start mysqld
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
一 無法啟動mysql,可以查看mysql日志 默認(rèn)路徑
/var/log/mysql.log
2020-03-20T02:12:57.667801Z 1 [ERROR] [MY-012271] [InnoDB] The innodb_system data file 'ibdata1' must be writable
2020-03-20T02:12:57.668066Z 1 [ERROR] [MY-012278] [InnoDB] The innodb_system data file 'ibdata1' must be writable
2020-03-20T02:12:57.668410Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2020-03-20T02:12:57.668897Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-03-20T02:12:57.669159Z 0 [ERROR] [MY-010119] [Server] Aborting
mysql日志報錯
根據(jù)日志查看提示录粱，是innodb文件沒有寫入權(quán)限
查找ibdata1文件路徑
[root@localhost ~]# find / -name ibdata1
/var/lib/mysql/ibdata1
[root@localhost ~]# chmod -R 777 /var/lib/mysql
[root@localhost ~]# chown mysql:mysql -R /var/lib/mysql
三 接著啟動服務(wù)
[root@localhost ~]# systemctl start mysqld.service
[root@localhost ~]# systemctl status mysqld.service
其他注意事項(xiàng)
另外注意一下mysql初始化的密碼 也記錄到 mysqld日志里面
[root@localhost ~]# cat /var/log/mysqld.log
2020-03-20T02:12:15.251589Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.19) initializing of server in progress as process 335
2020-03-20T02:12:19.068387Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: fyIGo9o9(t.p
2020-03-20T02:12:57.636850Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.19) starting as process 492
[root@host]# mysqladmin -u root password "new_password";
然后可以通過以下命令來連接到Mysql服務(wù)器：
[root@host]# mysql -u root -p Enter password:*******
出現(xiàn)問題的時候雌桑，要多查看日志。根據(jù)日志信息能鎖定問題
