![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL数据库
CleoL
这个作者很懒,什么都没留下…
展开
-
连接mysql时报错:1045-access denied for user 'root'@'localhost' using password yes
产生原因:可能是user表里存在两个root用户,第一个只允许本地连接远程连接时,会先去访问第一个root用户;解决方案:1、在mysql命令行中执行SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456'); GRANT ALL PRIVILEGES ON *.* TO 'root' @'%' IDENTIFIED BY '12...转载 2018-07-20 11:43:47 · 750 阅读 · 0 评论 -
MySQL数据库报Packet for query is too large 异常
报错信息摘要如下:Error querying database. Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1045 > 1024). You can change this value on the server by setting the max_allowed_pack...原创 2018-07-20 12:19:42 · 461 阅读 · 0 评论 -
某服务启动报错: ERROR 1018 (HY000): Can't read dir of './dbname/' (errno: 13 - Permission denied)
产生原因:之前更改了mysql basedir的属主解决方案:将mysql basedir目录的属主更改回mysql用户原创 2018-07-20 12:21:15 · 1015 阅读 · 0 评论