数据库mysql相关 Access denied for user ‘root‘@‘localhost‘ (using password: YES)

不念不忘少年蓝@ 2022-08-31 04:42 144阅读 0赞

**目录**

1273 - Unknown collation: 'utf8mb4\_0900\_ai\_ci'

10065 ：网络

数据库导入Sql文件：

Authentication plugin 'caching\_sha2\_password' cannot be loaded

navicate 界面，用户，建立连接，数据库关系

Access denied for user 'root'@'localhost' (using password: YES)

--------------------

# 1273 - Unknown collation: 'utf8mb4\_0900\_ai\_ci' #

**数据库复制之间的字符集应该继续拧匹配**

# ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTk4MjEz_size_16_color_FFFFFF_t_70][] #

# ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTk4MjEz_size_16_color_FFFFFF_t_70 1][] #

#  #

# 10065 ：网络 #

# ![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTk4MjEz_size_16_color_FFFFFF_t_70 2][] #

#  #

# 数据库导入Sql文件： #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTk4MjEz_size_16_color_FFFFFF_t_70 3][]

#  #

# [Authentication plugin 'caching\_sha2\_password' cannot be loaded][Authentication plugin _caching_sha2_password_ cannot be loaded] #

[https://www.cnblogs.com/zhurong/p/9898675.html][Authentication plugin _caching_sha2_password_ cannot be loaded]

# navicate 界面，用户，建立连接，数据库关系 #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTk4MjEz_size_16_color_FFFFFF_t_70 4][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTk4MjEz_size_16_color_FFFFFF_t_70 5][]

1.  建立的链接，（本地连接（localhost）和远程连接（带有ip地址的））
2.  建立的数据库（数据库名称，在jdbc驱动里面写）
3.  建立的用户（用户和连接是对应的，一个连接里面会有很多的数据库，每一个数据库对应很多的用户名）

##  ##

##  Access denied for user 'root'@'localhost' (using password: YES) ##

就是由于用户命或者密码不正确导致的

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTk4MjEz_size_16_color_FFFFFF_t_70 6][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTk4MjEz_size_16_color_FFFFFF_t_70 7][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTk4MjEz_size_16_color_FFFFFF_t_70]: /images/20220829/6331f23651864d51a58f64f6ddeb61f2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTk4MjEz_size_16_color_FFFFFF_t_70 1]: /images/20220829/1b4acb5a083948b59242a2fd1e59ce89.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTk4MjEz_size_16_color_FFFFFF_t_70 2]: /images/20220829/b09009bcbe9745eaa0c1af7b20570e59.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTk4MjEz_size_16_color_FFFFFF_t_70 3]: /images/20220829/565b7494f6974e82965ba8fa3c6ecc65.png
[Authentication plugin _caching_sha2_password_ cannot be loaded]: https://www.cnblogs.com/zhurong/p/9898675.html
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTk4MjEz_size_16_color_FFFFFF_t_70 4]: /images/20220829/bb6d8b3585834ab686cb8570c0725d26.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTk4MjEz_size_16_color_FFFFFF_t_70 5]: /images/20220829/b4a6766811e2402e98f48db235b9f7a7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTk4MjEz_size_16_color_FFFFFF_t_70 6]: /images/20220829/0979b71edacd4e83b7544b2a9c400a99.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM4OTk4MjEz_size_16_color_FFFFFF_t_70 7]: /images/20220829/65db68ab44ad4af592978c6051790c49.png