出現Field 'ssl_cipher' doesn't have a default value錯誤怎麼解決？？？

建立snort資料庫，建立snort使用者，將snort庫所有表的所有許可權賦予使用者snort。

mysql> create database snort;
Query OK, 1 row affected (0.06 sec)
建立資料庫

mysql> create user snort;
Query OK, 1 row affected (0.06 sec)
建立使用者snort

mysql> use mysql;
進入mysql庫
mysql> insert into user (Host,User,Password) values("localhost","snort",PASSWORD("112233445566"));
建立使用者，設定初始密碼(這樣做不行，會報標題上的錯誤)

mysql> update user set Password valuesPASSWORD("112233445566") where user='snort';
將已經建好的使用者，設定初始密碼

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
使改動生效；註：如果不執行該指令，則無法正常執行後續指令。
mysql> grant all on snort.* to 'snort'@'localhost';
Query OK, 0 rows affected (0.00 sec)
將snort庫的所有許可權賦予 snort使用者
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
使改動生效
mysql> show grants for snort@localhost;
+-------------------------------------------------------------------------------------+
| Grants for snort@localhost |
+-------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'snort'@'localhost' IDENTIFIED BY PASSWORD'1e6b29186dd45e97' |
| GRANT ALL PRIVILEGES ON `snort`.* TO 'snort'@'localhost' |
+-------------------------------------------------------------------------------------+