今天第一次把玩mysql,在默认数据库mysql中创建用户时报错:
ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SELECT host, user, password FROM user WHERE user = 'guest';
Empty set (0.23 sec)
mysql> INSERT INTO user
-> (host, user, password,
-> select_priv, insert_priv, update_priv)
-> VALUES ('localhost', 'scofy',
-> PASSWORD('mysql'), 'Y', 'Y', 'Y');
ERROR 1364 (HY000): Field 'ssl_cipher' doesn&