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)
[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)
Subscribe to:
Posts (Atom)