MySQL--问题及解决

￡神魔★判官ぃ 2023-06-22 13:38 11阅读 0赞

原文网址：[MySQL--问题及解决\_IT利刃出鞘的博客-CSDN博客][MySQL--_IT_-CSDN]

# 找不到jdbc.Driver #

错误日志

> java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

解决方法

> 对于IDEA  
> File=> project structure=> Modules=> Dependencies=> 添加MySQL驱动包（mysql-connector-java-5.1.39-bin.jar）=> Apply
> 
> 对于控制台  
> 将MySQL驱动包（mysql-connector-java-5.1.39-bin.jar）放到源文件目录下。

# 插入汉字报错 #

其他网址

> [ERROR 1366 (HY000): Incorrect string value错误解决办法][ERROR 1366 _HY000_ Incorrect string value]  
> [ERROR 1366 (HY000): Incorrect string value（5.7.25)\_数据库\_彭炜权的博客-CSDN博客][ERROR 1366 _HY000_ Incorrect string value_5.7.25_-CSDN]

错误日志

> ERROR 1366 (HY000): Incorrect string value: '\\xAE\\xE6\\x94\\xB9\\xE8\\xAE...' for column 'desc\_' at row 1

分析

>     show variables like 'character%';
> 
> ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70][]
> 
> 可以发现，数据库和服务器编码不一致。

永久解决方法（重启服务或关闭会话仍然有效）：修改配置文件，添加如下配置

[client]
    default-character-set = utf8
    [mysql]
    default-character-set = utf8
    [mysqld]
    character-set-server = utf8
    init-connect='set names utf8'

临时解决方法（重启服务或关闭会话失效）：

set global character_set_client = 'utf8';
    set global character_set_connection = 'utf8';
    set global character_set_database = 'utf8';
    set global character_set_results = 'utf8';
    set global character_set_server = 'utf8';

# 登录失败 #

失败日志

> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

解决方法

见：[MySQL基础系列--命令\_数据库\_feiying0canglang的博客-CSDN博客][MySQL_--_feiying0canglang_-CSDN] => 忘记密码解决方法

[MySQL--_IT_-CSDN]: https://knife.blog.csdn.net/article/details/103561520
[ERROR 1366 _HY000_ Incorrect string value]: http://www.dutycode.com/post-5.html
[ERROR 1366 _HY000_ Incorrect string value_5.7.25_-CSDN]: https://blog.csdn.net/weixin_44767769/article/details/90514605
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200508001806937.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ZlaXlpbmcwY2FuZ2xhbmc=,size_16,color_FFFFFF,t_70
[MySQL_--_feiying0canglang_-CSDN]: https://blog.csdn.net/feiying0canglang/article/details/103992791