mysql常见报错及问题排查

分手后的思念是犯贱 2023-07-19 10:58 128阅读 0赞

### mysql常见报错及问题排查 ###

*   *  \[Table 'xxx' doesn't exist\](https://blog.csdn.net/dhbfjh/article/details/105205312)
     *  \[Host \*\*\*.\*\*\*.\*\*\*.\*\*\* is not allowed to connect to this MySQL server\](https://blog.csdn.net/dhbfjh/article/details/105205239)
     *  \[ERROR 1819 (HY000): Your password does not satisfy the current policy requirements\](https://blog.csdn.net/dhbfjh/article/details/105205170)
     *  \[ERROR 1820: You must reset your password using ALTER USER statement before executing this statement\](https://blog.csdn.net/dhbfjh/article/details/105204955)
     *  mysql配置文件
     *  操作报错查看日志,日志路径/var/log/mysqld.log

## [Table ‘xxx’ doesn’t exist][Table _xxx_ doesn_t exist] ##

## [Host ***.\*\*\*.\*\*\*.*** is not allowed to connect to this MySQL server][Host _._._._ is not allowed to connect to this MySQL server] ##

## [ERROR 1819 (HY000): Your password does not satisfy the current policy requirements][ERROR 1819 _HY000_ Your password does not satisfy the current policy requirements] ##

## [ERROR 1820: You must reset your password using ALTER USER statement before executing this statement][ERROR 1820_ You must reset your password using ALTER USER statement before executing this statement] ##

## mysql配置文件 ##

![配置文件][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RoYmZqaA_size_16_color_FFFFFF_t_70]

## 操作报错查看日志,日志路径/var/log/mysqld.log ##

[Table _xxx_ doesn_t exist]: https://blog.csdn.net/dhbfjh/article/details/105205312
[Host _._._._ is not allowed to connect to this MySQL server]: https://blog.csdn.net/dhbfjh/article/details/105205239
[ERROR 1819 _HY000_ Your password does not satisfy the current policy requirements]: https://blog.csdn.net/dhbfjh/article/details/105205170
[ERROR 1820_ You must reset your password using ALTER USER statement before executing this statement]: https://blog.csdn.net/dhbfjh/article/details/105204955
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2RoYmZqaA_size_16_color_FFFFFF_t_70]: /images/20230528/dfab46a412d14a2db39b02262d04811d.png