Recently, a MySQL server I manage has shut down abnormally. I find some information in error log Plugin 'FEDERATED' is disabled. The FEDERATED storage engine is available beginning with MySQL 5.0.3. It is a storage engine that accesses data in…
Automatically Start MySQL Server on OS X Yosemite
MySQL can't start automatically on starts up in OS X Yosemite. Create /Library/LaunchDaemons/com.mysql.mysql.plist and save it with the following plist <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd"> <plist version="1.0"> <dict> <key>KeepAlive</key> <true /> <key>Label</key> <string>com.mysql.mysqld</string> <key>ProgramArguments</key> <array>…
Solve MySQL: Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Problem Initially I started mysql with incorrect and ran into error in the error log. 141005 12:00:00 [ERROR] Plugin 'InnoDB' init function returned error. 141005 12:00:00 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 141005 12:00:00 [ERROR] Unknown/unsupported storage…
Change MySQL root Password in OS X or Linux
If you have forgot the MySQL root password, can't remember or want to break in... you can reset the mysql database password from the command line in either OS X or Linux as long as you know the root user…