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.
Thanks very much for this post, its working now!
ReplyDeleteThanx alot, this was a great deal of help.
ReplyDeleteThanks, it works.
ReplyDeleteThanks a lot sir
ReplyDelete