Monday, September 7, 2009

MySql Error Message

Error 1:

[root@192.168.33.121mysql]-> INSERT INTO user (Host,User,Password) VALUES('%','nbpm',PASSWORD('nbpm'));
ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value

Fix:
[root@192.168.33.121mysql]-> INSERT INTO user (Host,User,Password,ssl_cipher,x509_issuer,x509_subject) VALUES ('%','nbpm',PASSWORD('nbpm'), 'NULL', 'NULL', 'NULL');
Query OK, 1 row affected (0.02 sec)

No comments:

Post a Comment