When applying security settings the configuration process will fail
NOTE:There is a bug in Version 5.8.8 that prevents security application to the MySQL instance.
The following window will appear during the MySQL 5.5.9 installation process as shown in Diagram 1.
The Error Message is as shown in diagram 1.
“The security settings could not be applied to the database because the connection has failed with following error. Error Nr:1364Field ‘authentication_string’ doesn’t have a default value…”message will display as shown in Diagram 1.
Follow these simple steps to successfully overcome this issue.
Click on Skip to close this window.
Diagram 1
The MySQL Server Instance Configuration wizard opens as shown in Diagram 2.
Security could not be