小虚竹的专栏

揭示十年数据库经验，告诉你如何轻松应对常见问题（SQL 小虚竹）

prepare语句的介绍，优点和注意点分析，实战演示如何使用prepare语句

查询插件，安装插件教程

忘记密码解决方案

开启和关闭mysql系统参数(多环境)

mysql问题及解决方案

mysql 问题及解决方案

Mysql出现问题：ERROR 1005 (HY000): Can't create table 解决方案

Mysql出现问题：ERROR 1011 (HY000 (ER_CANT_DELETE_FILE)): Error on delete of ‘%s‘ 解决方案

Mysql出现问题：ERROR 1012:Can‘t read record in system table (errno: %d)解决方案

Mysql出现问题：ERROR 1020: Record has been changed since last read in table解决方案

Mysql出现问题：ERROR 1021: Disk full (%s)； waiting for someone to free some space...解决方案

Mysql出现问题：ERROR 1022 (23000): Can‘t write； duplicate key in table ‘**‘解决方案

Mysql出现问题：ERROR 1023 (HY000 (ER_ERROR_ON_CLOSE)): Error on close of ‘%s‘ (errno: %d)解决方案

Mysql出现问题：ERROR 1024 (HY000 (ER_ERROR_ON_READ)): Error reading file ‘%s‘ (errno: %d)解决方案

Mysql出现问题：ERROR 1025 (HY000 (ER_ERROR_ON_RENAME)): Error on rename of ‘%s‘ to ‘%s‘ (errno: %d)解决方案

Mysql出现问题：ERROR 1026 (HY000 (ER_ERROR_ON_WRITE)): Error writing file ‘%s‘ (errno: %d)解决方案

Mysql出现问题：ERROR 1032 (HY000 (ER_KEY_NOT_FOUND)): Can‘t find record in ‘%s‘解决方案

Mysql出现问题：ERROR 1036 (HY000 (ER_OPEN_AS_READONLY)): Table ‘%s‘ is read only解决方案

Mysql出现问题：ERROR 1037 (HY001 (ER_OUTOFMEMORY)): Out of memory; restart server and try again (needed %d bytes)解决方案

Mysql出现问题：ERROR 1038 (HY001 (ER_OUT_OF_SORTMEMORY)): Out of sort memory; increase server sort buffer size 解决方案

Mysql出现问题：ERROR 1040 (08004 (ER_CON_COUNT_ERROR)): Too many connections解决方案

Mysql出现问题：ERROR 1041 ( HY000 (ER_OUT_OF_RESOURCES)): Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space解决方案

Mysql出现问题：ERROR 1042 (08S01 (ER_BAD_HOST_ERROR)): Can‘t get hostname for your address解决方案

Mysql出现问题：ERROR 1043 (08S01 (ER_HANDSHAKE_ERROR)): Bad handshake解决方案

Mysql出现问题：ERROR 1044 (42000 (ER_DBACCESS_DENIED_ERROR)): Access denied for user '%s'@'%s' to database '%s'解决方案

Mysql出现问题：ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)解决方案

Mysql出现问题：ERROR 1050 (42S01 (ER_TABLE_EXISTS_ERROR)): Table ‘%s‘ already exists解决方案

Mysql出现问题：ERROR 1054 : Unknown column '**' in 'field list'解决方案

Mysql出现问题：ERROR 1062 (23000): Duplicate entry ‘‘ for key ‘PRIMARY‘解决方案

Mysql出现问题：ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corres解决方案

Mysql出现问题：ERROR 1081 (08S01 (ER_IPSOCK_ERROR)): Can‘t create IP socket解决方案

Mysql出现问题：ERROR 1091 (42000): Can‘t DROP ‘**‘； check that column/key exists解决方案

Mysql出现问题：ERROR 1114 (HY000 (ER_RECORD_FILE_FULL)): The table ‘%s‘ is full解决方案

Mysql出现问题：ERROR 1116 (HY000 (ER_TOO_MANY_TABLES)): Too many tables; MySQL can only use %d tables in a join解决方案

Mysql出现问题：ERROR 1129 ( HY000 (ER_HOST_IS_BLOCKED)): Host '%s' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'解决方案

Mysql出现问题：ERROR 1130 ( HY000 (ER_HOST_NOT_PRIVILEGED)): Host '%s' is not allowed to connect to this MySQL server解决方案

Mysql出现问题：ERROR 1133 ( 42000 (ER_PASSWORD_NO_MATCH)): Can't find any matching row in the user table解决方案

Mysql出现问题：ERROR 1141 ( 42000 (ER_NONEXISTING_GRANT)): There is no such grant defined for user '%s' on host '%s'解决方案

Mysql出现问题：ERROR 1142 ( 42000 (ER_TABLEACCESS_DENIED_ERROR)): %s command denied to user ‘%s‘@‘%解决方案