MySQL8 Tips

1.Navicat远程连接问题

创建一个账户,例如remote,密码A123456!

create user 'remote'@'%' identified by 'A123456!';

也可以把%换为指定ip

刷新权限

flush privileges;

增加授权

grant all privileges on *.* to 'remote'@'%' with grant option;

运行Navicat,使用新创建的账户和密码进行连接。

2.关闭only_full_group_by模式

sudo vi /etc/my.cnf

添加以下内容

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
# mysql8 

评论

Your browser is out-of-date!

Update your browser to view this website correctly. Update my browser now

×