15,041
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
m
→Miscellaneous Tool-Specific Errors
| Line 516: | Line 516: | ||
plain_text.sql: UTF-8 Unicode text, with very long lines | plain_text.sql: UTF-8 Unicode text, with very long lines | ||
</pre> | </pre> | ||
=== Errcode: 13 Permission denied === | |||
The message occurred after executed {{kbd | key=<nowiki>mysqld.exe --datadir=..\data --console</nowiki>}} when I tried to start the service. (Version of MySQL：5.5.5-10.0.12-MariaDB on {{Win}}) | |||
<pre> | |||
> mysqld.exe --datadir=..\data --console | |||
180430 10:33:38 [ERROR] mysqld.exe: File 'C:\MariaDB_10.0\bin\..\data\aria_log_control' not found (Errcode: 13 "Permission denied") | |||
180430 10:33:38 [ERROR] mysqld.exe: Got error 'Can't open file' when trying to use aria control file 'C:\MariaDB_10.0\bin\..\data\aria_log_control' | |||
180430 10:33:38 [ERROR] Plugin 'Aria' init function returned error. | |||
180430 10:33:38 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed. | |||
180430 10:33:38 [Note] InnoDB: Using mutexes to ref count buffer pool pages | |||
180430 10:33:38 [Note] InnoDB: The InnoDB memory heap is disabled | |||
180430 10:33:38 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions | |||
180430 10:33:38 [Note] InnoDB: Compressed tables use zlib 1.2.3 | |||
180430 10:33:38 [Note] InnoDB: Not using CPU crc32 instructions | |||
180430 10:33:38 [Note] InnoDB: Initializing buffer pool, size = 4.0G | |||
180430 10:33:38 [Note] InnoDB: Completed initialization of buffer pool | |||
180430 10:33:38 [ERROR] InnoDB: .\ibdata1 can't be opened in read-write mode | |||
180430 10:33:38 [ERROR] InnoDB: The system tablespace must be writable! | |||
180430 10:33:38 [ERROR] Plugin 'InnoDB' init function returned error. | |||
180430 10:33:38 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. | |||
180430 10:33:38 [Note] Plugin 'FEEDBACK' is disabled. | |||
180430 10:33:38 [ERROR] Unknown/unsupported storage engine: innodb | |||
180430 10:33:38 [ERROR] Aborting | |||
180430 10:33:38 [Note] mysqld.exe: Shutdown complete | |||
</pre> | |||
Solutions: | |||
Open the command line with administrative privileges. (How to: [https://www.howtogeek.com/194041/how-to-open-the-command-prompt-as-administrator-in-windows-8.1/ How to Open the Command Prompt as Administrator in Windows 8 or 10]) | |||
== References == | == References == | ||