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表中增加一行数据。