14,982
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
+ Errcode: 13 Permission denied
(+ Errcode: 13 Permission denied) |
|||
| Line 58: | Line 58: | ||
* "You do not use {{kbd | key=<nowiki>$result = $stmt->fetchAll();</nowiki>}} with update or insert queries" <ref>[https://stackoverflow.com/questions/12979510/pdo-error-sqlstatehy000-general-error-when-updating-database php - PDO error: " SQLSTATE[HY000]: General error " When updating database - Stack Overflow]</ref>. | * "You do not use {{kbd | key=<nowiki>$result = $stmt->fetchAll();</nowiki>}} with update or insert queries" <ref>[https://stackoverflow.com/questions/12979510/pdo-error-sqlstatehy000-general-error-when-updating-database php - PDO error: " SQLSTATE[HY000]: General error " When updating database - Stack Overflow]</ref>. | ||
* You do not use {{kbd | key=<nowiki>$result = $stmt->fetchAll();</nowiki>}} in the query {{kbd | key=<nowiki>INTO OUTFILE ...</nowiki>}} <ref>[http://www.tech-recipes.com/rx/1475/save-mysql-query-results-into-a-text-or-csv-file/ Save MySQL query results into a text or CSV file]</ref><ref>[https://stackoverflow.com/questions/13369164/cant-create-write-to-file-errcode-22 mysql - Can't create/write to file (Errcode: 22) - Stack Overflow]</ref>. | * You do not use {{kbd | key=<nowiki>$result = $stmt->fetchAll();</nowiki>}} in the query {{kbd | key=<nowiki>INTO OUTFILE ...</nowiki>}} <ref>[http://www.tech-recipes.com/rx/1475/save-mysql-query-results-into-a-text-or-csv-file/ Save MySQL query results into a text or CSV file]</ref><ref>[https://stackoverflow.com/questions/13369164/cant-create-write-to-file-errcode-22 mysql - Can't create/write to file (Errcode: 22) - Stack Overflow]</ref>. | ||
== 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) | |||
<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]) | |||
== Error!: SQLSTATE[HY000]: General error: 3 Error writing file 'xxx\Temp\xxx.tmp' (Errcode: 28 - No space left on device) == | == Error!: SQLSTATE[HY000]: General error: 3 Error writing file 'xxx\Temp\xxx.tmp' (Errcode: 28 - No space left on device) == | ||