您的位置: 首页 > 文章 > mysql常见报错及问题排查

mysql常见报错及问题排查

分类: 文章 • 2025-01-16 19:55:10

mysql常见报错及问题排查

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

Table ‘xxx’ doesn’t exist

Host ... is not allowed to connect to this MySQL server

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

mysql配置文件

mysql常见报错及问题排查

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