CentOS7 安装 Mysql5.6.40

CentOS7.5二进制安装MySQL-5.6.40

安装之后登陆不上,mysql.user 表是空的时:

Mysql User表为空
mysql创建用户报错ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value

修改配置文件,我这里是 /etc/my.cnf :

① 添加 skip-grant-tables
② sql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION 改成
sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

重启 mysql
# mysql
> select mysql;
> INSERT INTO user(host, user, password, select_priv, insert_priv, update_priv) VALUES ('localhost', 'root', PASSWORD('fuck'), 'Y', 'Y','Y');
添加成功,就可以使用 root 登陆了,密码是 fuck。

已经有可以登录上,新建用户时:

Mysql添加用户错误:ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value解决方法

添加权限:
> grant all privileges on . to 'username'@'hostname' identified by 'passwd';

原文地址:https://www.cnblogs.com/catyuang/p/11511632.html