Pages

Thursday, March 31, 2011

MySQL Server Error Nr.1364 Field 'authentication_string' doesn't have a default value while Configuring Server Instance

While configuring MySQL Server Instance of MySQL Server 5.5, it generate the error message  Error Nr.1364 Field 'authentication_string' doesn't have a default value. In my knowledge it's a bug. We can override this by changing the option in Server Instance configuration wizard. This error get only when we are selecting 'Enable root access from remote machines'. so in this case (MySQL 5.5) first we skip this option and complete the configuration process. Then connect the MYSQL database and alter column 'authentication_string' as null in table 'user'. After that, use the MySQL Server Instance Configuration for modify the setting of Instance now you can select 'Enable root access from remote machines', now it execute the configuration successfully.

4 comments: