mysql.server start The server quit without updating PID file問題解決

mysql.server start The server quit without updating PID file問題解決

$ mysql.server start
Starting MySQL
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/fdipzonedeMacBook-Air.local.pid).

180718 18:50:00 InnoDB: If you tried to add new data files, and it failed here,
180718 18:50:00 InnoDB: you should now edit innodb_data_file_path in my.cnf back
180718 18:50:00 InnoDB: to what it was, and remove the new ibdata files InnoDB created
180718 18:50:00 InnoDB: in this failed attempt. InnoDB only wrote those files full of
180718 18:50:00 InnoDB: zeros, but did not yet use them in any way. But be careful: do not
180718 18:50:00 InnoDB: remove old data files which contain your precious data!
180718 18:50:00 [ERROR] Plugin 'InnoDB' init function returned error.
180718 18:50:00 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
180718 18:50:00 [ERROR] Unknown/unsupported storage engine: InnoDB
180718 18:50:00 [ERROR] Aborting

180718 18:50:00 [Note] /usr/local/Cellar/mysql@5.5/5.5.60/bin/mysqld: Shutdown complete

180718 18:50:00 mysqld_safe mysqld from pid file /usr/local/var/mysql/wangli.local.pid ended

解決方法

進入mysql目錄，一般是：/usr/local/var/mysql/

刪除ib_logfile*

刪除ibdata*

刪除所有資料庫物理目錄（例如資料庫為test_db,則執行rm -rf test_db）

重啟動mysql

重新建立資料庫或使用備份覆蓋