mysql Field ‘ssl_cipher‘ doesn‘t have a default value的解决

1、执行sql的时候报错：
16:48:00    INSERT INTO mysql.user (Host,User,authentication_string) VALUES('%','root', PASSWORD('12323'))    Error Code: 1364. Field 'ssl_cipher' doesn't have a default value    0.000 sec

1、解决，执行命令：

mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "密码" WITH GRANT OPTION;

mysql> flush privileges;

2、然后我们来看一下mysql数据库的表user，发现执行上面的语句以后，会在数据库mysql的user表中增加一行数据。