I have just installed MySQL for the first time, and I am just getting started setting up a new database.
When adding a user to a MySQL server using the command:
INSERT INTO mysql.user(User, Host, Password) VALUES('username', '%',
I found that I received the error:
Field ssl_cipher doesn't have a default value. 1364
Looking on the MySQL bug list, it appears that plenty of people are having the same problem on windows, but there was one solution suggested that fixed the problem:
INSERT INTO mysql.user(User, Host, Password, ssl_cipher, x509_issuer, x509_subject)
Password('password'), '', '', '')
This worked perfectly.
As we are just inserting empty values into those columns, I am sure that the table could be altered to have a default value of an empty string for each of the three additional columns. a puzzle for another day.