If MySQL or the associated Windows service can not start,
or a post-startup INSTALL PLUGIN
statement fails,
look at the MySQL error log (usually named
and located in the MySQL machine_name
.errdata
directory) for the
detailed error message.
The log is in chronological order, so look at the end of the file.
Try to resolve the problem based on other information in the
message.
Error Condition or Message | Possible Solution |
---|---|
Can't open shared library |
Diagnose the cause from the following message details. |
API version for STORAGE ENGINE plugin is too different |
The version of the Plugin is not compatible with the version of the MySQL server. Consult the compatibility chart . |
No such file or directory |
Check that the file ha_innodb_plugin.so
or .dll
was copied to the
correct location. Confirm that you specified the right file name
(ha_innodb_plugin.so
or .dll
for the library from the InnoDB web site;
ha_innodb_plugin.so
or .dll
for the library supplied along with
MySQL 5.1.38 and up.)
|
Permission denied |
Check that the folder and file access permissions are set
properly. The mysqld process
must have permission to read the file
ha_innodb_plugin.dll and to read files in
the plugin folder. On Windows XP, file permissions
can be seen or changed by right-clicking on a file and
pressing Properties, and then the Security Tab. To see
the Security Tab, you may need to adjust the Folder
Options on the Control Panel to turn off “Use
Simple File Sharing”. |
Can't open shared library
' |
Ensure that |
Note: The Information Schema tables are themselves plugins to the MySQL server, but they depend on having the InnoDB storage engine plugin installed as well. These tables will appear to be empty if the storage engine is not installed.
This is the User’s Guide for InnoDB Plugin 1.0.6 for MySQL 5.1, generated on March 4, 2010 (rev 673:680M).