MySQL 5.5.8 – Problem while Creating new User (SQL Error (1364): Field ‘authentication_string’ doesn

最新推荐文章于 2024-04-01 11:30:00 发布

转载最新推荐文章于 2024-04-01 11:30:00 发布 · 833 阅读

数据库/Mysql 同时被 2 个专栏收录

16 篇文章

订阅专栏

Others

11 篇文章

订阅专栏

本文提供了解决MySQL升级至5.5版本过程中可能遇到的问题的方法，包括两种解决方案：使用HeidiSQL 6.0创建用户或者修改users表的定义，允许authentication_string字段为null。

Solution: There are 2 ways to fix the problem:

A) Download HeidiSQL 6.0 and try creating user again.

B) Go to "users" table in "mysql" db and change the definition of table, alter table structure and allow null value for "authentication_string" field.

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

Ideally one should change the query if they are writing SQL statement to create user manually, but when we are using such tools it's not possible to do that and not logical either.

If you have encountered any bumps on the road while upgrading to MySQL 5.5, please do share with us.