The innodb_system data file 'ibdata1' must be writable
之前MySQL還好好的,今天突然無法啟動了
ps -ef|grep mysql
看到有啟動的程式,不過啟動失敗了,然後 根據
--log-error=/usr/local/mysql/data/mysqld.local.err
到錯誤日誌中看了提示的錯誤:
The innodb_system data file 'ibdata1' must be writable
應該是檔案的操作許可權不夠,可以修改下該檔案的讀寫許可權或目錄下所有檔案的許可權。
chmod -R 777 /usr/local/mysql/data/
執行上面命令,重啟了MySQL就可以了。
參考資料
相關文章
- MySQL啟動報錯InnoDB: The innodb_system data file './ibdata1' is of a differentMySql
- Property "visible" must be accessed with "$data.visible"
- Property "visible" must be accessed with "$data.visible" because properties
- cannot use '/dev/da1': must be a block device or regular filedevBloC
- ELF file data encoding not little-endianEncoding
- ERROR3948: Loading local data is disabled - this must be enabled on both the client and server sidesErrorclientServerIDE
- configurable、enumerable和writable
- oracle ORA-01157: cannot identify/lock data file 64OracleIDE
- brew update /usr/local is not writable
- oracle 匯入報錯:field in data file exceeds maximum lengthOracle
- vue專案報錯[Vue warn]: Property “visible“ must be accessed with “$data.visible“ because properties startVue
- mysql ibdata1太大的原因MySql
- centos 16安裝PHP7.0 異常 No pool defined. at least one pool section must be specified in config fileCentOSPHPAST
- Flutter:VM snapshot must be valid. Check failed: vm. Must be able to initializeFlutterAI
- [ERROR] InnoDB: ibdata1 different size (rounded down to MB)Error
- find: paths must precede expression:Express
- Node.js Writable Stream的實現簡析Node.js
- mysql innodb_data_file_path引數忘記設定或者重新調整辦法MySql
- Docker 版本升級後提示 "graph" config file option is deprecated use "data-root" instead 問題Docker
- Qt QWidget Must construct a QApplication before a QWidgetQTStructAPP
- 解讀Node核心模組Stream系列一(Writable和pipe)
- 關於vsftpd的refusing to run with writable root inside chroot()問題FTPIDE
- Solution - Codeforces 1166E The LCMs Must be Large
- TypeError: The ‘compilation‘ argument must be an instance of Compilation 報錯Error
- 【Redis】錯誤:failed: Hostname must not be empty or nullRedisAINull
- node那點事(二) — Writable streams(可寫流)、自定義流
- node那點事(二) -- Writable streams(可寫流)、自定義流
- cat > file << EOF 與 cat > file << -
- Big Data and Data Warehousing
- ibdata1檔案損壞時恢復InnoDB單表測試
- File
- python argument 1 must be 2-item sequence, not intPython
- 解決:java.lang.IllegalArgumentException: String must not be emptyJavaException
- How to Convert Class File to Java File Online?Java
- before install octave package you must be install gcc-fortranPackageGC
- Property visible must be accessed with $ or _ are not proxied in the Vue instance to prevent錯誤Vue
- docker fileDocker
- mysql 5.7 刪除ibdata1 、ib_logfile 檔案的資料恢復MySql資料恢復
- include "head_file" 和 include <head_file>