![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL
xiaowen5555555
这个作者很懒,什么都没留下…
展开
-
mysql8 启动报错:Error while setting value ‘STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DI
Error while setting value 'STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'.原创 2022-11-02 17:06:11 · 5200 阅读 · 0 评论 -
Mysql 8.0+ 修改密码
mysql -u root -p ‘原来的密码’ //进入数据库中show databases;use mysql;使用下面sql修改密码:ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘你的密码’; 退出登陆,然后使用设置新的密码登陆Mysql...原创 2018-09-03 09:31:47 · 4820 阅读 · 0 评论 -
MySQL 8.0 Public Key Retrieval is not allowed 错误的解决方法
在使用 MySQL 8.0 时重启应用后提示 com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:Public Key Retrieval is not allowed最简单的解决方法是在连接字符串后面添加allowPublicKeyRetrieval=true文档中(https://mysql-net.github.io/MySqlConnector/connection-options/)给出的解释是:如果原创 2021-12-13 10:40:27 · 116 阅读 · 0 评论