MySQL user addition Error
How to solve the problem when adding a user to MySQL
For example, add a user
Insert into mysql. user (Host, User, Password) values ("localhost", "test", password ("1234 "));
Error:
ERROR 1364 (HY000): Field 'ssl _ cipher 'doesn' t have a default value ERROR
For MySQL 5.6 and later versions, I operate on MySQL.
The correct method is as follows:
Grant usage on *. * TO 'user01' @ 'localhost' identified by '000000' with grant option;
User: user01, password: 123456, so that a new user is added and no error occurs.
-------------------------------------- Split line --------------------------------------
Install MySQL in Ubuntu 14.04
MySQL authoritative guide (original book version 2nd) Clear Chinese scan PDF
Ubuntu 14.04 LTS install LNMP Nginx \ PHP5 (PHP-FPM) \ MySQL
Build a MySQL Master/Slave server in Ubuntu 14.04
Build a highly available distributed MySQL cluster using Ubuntu 12.04 LTS
Install MySQL5.6 and Python-MySQLdb in the source code of Ubuntu 12.04
MySQL-5.5.38 universal binary Installation
-------------------------------------- Split line --------------------------------------
This article permanently updates the link address: