14,982
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
Could not start MySQL service on Windows
(Could not start MySQL service on Windows) |
|||
| Line 33: | Line 33: | ||
</pre> | </pre> | ||
== | == Could not open single-table tablespace file filename.ibd == | ||
Version: XAMPP 5.6.15-1 on {{Mac}} | Version: XAMPP 5.6.15-1 on {{Mac}} | ||
| Line 44: | Line 44: | ||
# If the MySQL service started successfully, edit the MySQL configuration file and mark this line : {{kbd | key=<nowiki>#innodb_force_recovery = 1</nowiki>}} | # If the MySQL service started successfully, edit the MySQL configuration file and mark this line : {{kbd | key=<nowiki>#innodb_force_recovery = 1</nowiki>}} | ||
# Restart the MySQL service | # Restart the MySQL service | ||
== Could not start MySQL service on Windows == | |||
checklist | |||
# [https://dev.mysql.com/doc/refman/5.7/en/data-directory.html MySQL Data Directory] was allowed to written by {{kbd | key=NETWORK SERVICE}} on Windows Server 2008<ref>[https://errerrors.blogspot.tw/2016/12/mysql-windows-server-2008-r2.html 如何修改 MySQL 伺服器的資料目錄 (Windows Server 2008 R2)]</ref> | |||
# Directory {{kbd | key=secure-file-priv}} was allowed to written by {{kbd | key=NETWORK SERVICE}} on Windows Server 2008 | |||
== Caught exception: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined == | == Caught exception: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined == | ||