Monday, September 7, 2009

MySQL Command Line 2


To check mysql software version:

[root@192.168.33.121(none)]-> select version();
+---------------------+
version()
+---------------------+
5.0.85-community-nt
+---------------------+
1 row in set (0.00 sec)

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)