MySQL 5.5.8 – Problem while Creating new User (SQL Error (1364): Field ‘authentication_string’ doesn
来源:互联网 发布:unity3d 剧情插件 编辑:程序博客网 时间:2024/05/18 03:21
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.
0 0
- MySQL 5.5.8 – Problem while Creating new User (SQL Error (1364): Field ‘authentication_string’ doesn
- 安装mysql 5.5.8 Error Nr.1364 authentication_string
- 安装mysql 5.5.8 Error Nr.1364 authentication_string
- 安装mysql 5.5.8 Error Nr.1364 authentication_string
- MySQL 5.5.9 Installation Problem security settings could not be applied 1364 authentication_string
- MySQL添加新用户 出现mysql]ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- mysql]ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- [mysql]ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- [mysql]ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- MySQL创建用户 :ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- mysql创建用户报错ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- [mysql]ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
- MYSQL:ERROR: Field '***' doesn't have a default value
- MySQL [ERROR] Table 'mysql.user' doesn't exist
- [亲测][解决方法]MySQL #1364 – Field “details” doesn’t have a default value
- java.sql.SQLException: General error, message from server: "Field 'ID' doesn't have a default value
- [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- MySQL:Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
- HDU 5224 Tom and paper
- MongoDB小技巧
- linux-3.12.48内核向at91sam9g25平台移植小结
- CentOS6.4上单个目录下最大能建的文件个数
- Everything研究之读取NTFS下的USN日志文件(1)
- MySQL 5.5.8 – Problem while Creating new User (SQL Error (1364): Field ‘authentication_string’ doesn
- android studio 1.4正式版 配置ndk
- SQL*Loader加载数据
- 如何更改VS2013中的背景色
- AllJoyn架构
- java学习中遇到的问题
- 解决MathPage.wll文件找不到的问题(找了好久的良心之作)
- 仿CSDN安卓客户端(二)-----从网络上获取并解析html文件
- IOS网络图片缓存详解