MySQL Authentication String error

If you see MySQL authentication error during installation. It is very simple to fix the error.

The following error appeared in the error dialog box when you click the Execute button.

Error. 1364 "field authentication string doesn't have a default value"

First, we have to log in through the command prompt.

C:/>mysql -u root -p

Enter password : *****

mysql>use mysql;

ALTER TABLE user CHANGE COLUMN authentication_string authentication_string TEXT NULL COLLATE utf8_bin AFTER plugin;

After that, again start the installation configuration wizard from the MySQL Installation menu from Start.

Now the process will be successfully complete.

Thanks,

Veera,

System Engineer,

Climb Inc, Tokyo.

http://www.climb.co.jp

veerasek@hotmail.com