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
- mysql錯誤: [ERROR] InnoDB: auto-extending data file /data/ibdata1 is of a different size 768 pages...MySqlError
- SSH無法啟動,報告/var/empty/sshd must be owned by root and not group or world-writable
- cannot use '/dev/da1': must be a block device or regular filedevBloC
- 除錯記錄:The public type must be defined in its own file除錯
- Warning: World-writable config file '/etc/my.cnf' is ignored
- MYSQL Warning: World-writable config file './my.cnf' is ignoredMySql
- Property "visible" must be accessed with "$data.visible"
- HP -Data Protector Restore file systemREST
- java.util.zip.ZipException:ZIP file must have at least one entryJavaExceptionAST
- sqlldr Field in data file exceeds maximum lengthSQL
- data file int write和db file sequential read個人想法
- Property "visible" must be accessed with "$data.visible" because properties
- Make NTFS writable on macOSMac
- Unload data to a flat file from Oracle databaseOracleDatabase
- brew update /usr/local is not writable
- ELF file data encoding not little-endianEncoding
- HP -Data Protector Restore file system【Blog 搬家】REST
- [轉載]Oracle等待事件Data file init writeOracle事件
- ERROR3948: Loading local data is disabled - this must be enabled on both the client and server sidesErrorclientServerIDE
- oracle10g 資料檔案頭data file header(file header)OracleHeader
- Error: parent directory is world writable but not stickyError
- GoldenGate replication using a data definition file and DEFGEN utilityGo
- oracle 匯入報錯:field in data file exceeds maximum lengthOracle
- 【蓋國強】Oracle Wait Event:Data file init writeOracleAI
- It's a must to ghd
- MySQL資料匯入匯出之Load data fileMySql
- mysql ibdata1太大的原因MySql
- configurable、enumerable和writable
- ORA-01157: cannot identify/lock data file %s - see DBWR trace file的處理IDE
- XX must be built with ARCUI
- sqlldr匯入資料包錯 Field in data file exceeds maximum lengthSQL
- [20130409]Data file init write等待事件.txt事件
- ORA-03297: file contains used data beyond requested RESIZE valueAI
- iOS swift 2 2 拒絕2 23 Apps must follow the iOS Data Storage GuidelineiOSSwiftAPPGUIIDE
- vue專案報錯[Vue warn]: Property “visible“ must be accessed with “$data.visible“ because properties startVue
- oracle ORA-01157: cannot identify/lock data file 64OracleIDE
- Clone Madison 12R TEST application with customized data file locationAPPZed