Troubleshooting of MySQL errors: Revision history

16 April 2020

• curprev 15:0615:06, 16 April 2020‎ Unknown user talk‎ m 28,876 bytes +53‎ →‎ERROR 1366: Incorrect string value undo
• curprev 14:3114:31, 16 April 2020‎ Unknown user talk‎ 28,823 bytes +486‎ + ERROR 1366: Incorrect string value undo

2 December 2019

• curprev 15:3415:34, 2 December 2019‎ Planetoid talk contribs‎ m 28,337 bytes +19‎ →‎command not found: mysqldump undo

31 May 2019

• curprev 11:0411:04, 31 May 2019‎ Planetoid talk contribs‎ 28,318 bytes +311‎ ERROR 1049 (42000): Unknown database undo

23 May 2019

• curprev 18:1218:12, 23 May 2019‎ Planetoid talk contribs‎ 28,007 bytes +1,091‎ →‎Could not start MySQL service on Windows undo

17 April 2019

• curprev 17:3217:32, 17 April 2019‎ Planetoid talk contribs‎ m 26,916 bytes +142‎ →‎Error!: SQLSTATE[42000]: Syntax error or access violation undo
• curprev 12:2012:20, 17 April 2019‎ Planetoid talk contribs‎ m 26,774 bytes +139‎ →‎Error!: SQLSTATE[42000]: Syntax error or access violation undo

21 January 2019

• curprev 11:3411:34, 21 January 2019‎ Planetoid talk contribs‎ m 26,635 bytes −8‎ →‎ERROR 2002 (HY000): Cannot connect: SQLSTATE[HY000] [2002] undo
• curprev 11:3311:33, 21 January 2019‎ Planetoid talk contribs‎ 26,643 bytes +36‎ →‎ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql.sock' undo

19 January 2019

• curprev 13:4713:47, 19 January 2019‎ Planetoid talk contribs‎ m 26,607 bytes +2‎ Text replacement - "errerrors.blogspot.tw" to "errerrors.blogspot.com" undo

13 November 2018

• curprev 19:0919:09, 13 November 2018‎ Planetoid talk contribs‎ m 26,605 bytes +51‎ →‎ERROR 1052 - Column 'column_name' in field list is ambiguous undo
• curprev 19:0719:07, 13 November 2018‎ Planetoid talk contribs‎ 26,554 bytes +442‎ + ERROR 1052 undo

15 August 2018

• curprev 12:1412:14, 15 August 2018‎ Planetoid talk contribs‎ m 26,112 bytes −15‎ →‎ERROR 1206: The total number of locks exceeds the lock table size undo
• curprev 10:1110:11, 15 August 2018‎ Planetoid talk contribs‎ m 26,127 bytes +351‎ →‎ERROR 1206: The total number of locks exceeds the lock table size undo

21 May 2018

• curprev 12:1112:11, 21 May 2018‎ Planetoid talk contribs‎ 25,776 bytes +1,043‎ ERROR: ASCII '\0' appeared in the statement, but this is not allowed unless option undo

11 May 2018

• curprev 16:3216:32, 11 May 2018‎ Planetoid talk contribs‎ 24,733 bytes +370‎ + Error!: SQLSTATE[42000]: Syntax error or access violation undo

10 May 2018

• curprev 11:5711:57, 10 May 2018‎ Planetoid talk contribs‎ 24,363 bytes +498‎ Could not start MySQL service on Windows undo

3 May 2018

• curprev 18:3318:33, 3 May 2018‎ Planetoid talk contribs‎ m 23,865 bytes +144‎ →‎ERROR 1044 (42000): Access denied for user 'USER'@'localhost' to database 'DATABASE_NAME' undo
• curprev 14:0814:08, 3 May 2018‎ Planetoid talk contribs‎ 23,721 bytes +524‎ →‎ERROR 1044 (42000): Access denied for user 'USER'@'localhost' to database 'DATABASE_NAME' undo

30 April 2018

• curprev 10:4710:47, 30 April 2018‎ Planetoid talk contribs‎ m 23,197 bytes 0‎ No edit summary undo
• curprev 10:4610:46, 30 April 2018‎ Planetoid talk contribs‎ 23,197 bytes +411‎ →‎ERROR 1017 - Can't find file: '.\DATABASE\TABLE.frm' (errno: 22 - Invalid argument) undo
• curprev 10:4210:42, 30 April 2018‎ Planetoid talk contribs‎ m 22,786 bytes +11‎ →‎Errcode: 13 Permission denied undo
• curprev 10:4110:41, 30 April 2018‎ Planetoid talk contribs‎ 22,775 bytes +1,950‎ + Errcode: 13 Permission denied undo

25 April 2018

• curprev 10:1110:11, 25 April 2018‎ Planetoid talk contribs‎ 20,825 bytes +110‎ →‎ERROR 1114 (HY000): The table `TABLE_NAME` is full undo

23 April 2018

• curprev 10:4810:48, 23 April 2018‎ Planetoid talk contribs‎ m 20,715 bytes +3‎ →‎ERROR 1267: Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'concat' undo
• curprev 10:4810:48, 23 April 2018‎ Planetoid talk contribs‎ 20,712 bytes +669‎ +Error 1267 undo

11 April 2018

• curprev 18:3918:39, 11 April 2018‎ Planetoid talk contribs‎ m 20,043 bytes −148‎ →‎ERROR 1235: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery' undo
• curprev 18:3918:39, 11 April 2018‎ Planetoid talk contribs‎ 20,191 bytes +35‎ →‎ERROR 1206: The total number of locks exceeds the lock table size undo
• curprev 18:3818:38, 11 April 2018‎ Planetoid talk contribs‎ 20,156 bytes +640‎ →‎ERROR 1206: The total number of locks exceeds the lock table size undo

8 April 2018

• curprev 10:2510:25, 8 April 2018‎ Planetoid talk contribs‎ m 19,516 bytes 0‎ →‎references undo
• curprev 10:2010:20, 8 April 2018‎ Planetoid talk contribs‎ 19,516 bytes +1,601‎ +Error!: SQLSTATE[HY000]: General error: 3 Error writing file 'xxx\Temp\xxx.tmp' (Errcode: 28 - No space left on device) undo

5 April 2018

• curprev 18:0618:06, 5 April 2018‎ Planetoid talk contribs‎ m 17,915 bytes 0‎ →‎ERROR 1206: The total number of locks exceeds the lock table size undo
• curprev 18:0418:04, 5 April 2018‎ Planetoid talk contribs‎ 17,915 bytes +306‎ →‎ERROR 1206: The total number of locks exceeds the lock table size undo

3 April 2018

• curprev 16:2916:29, 3 April 2018‎ Planetoid talk contribs‎ 17,609 bytes +343‎ →‎Error!: SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied undo

9 March 2018

• curprev 17:0617:06, 9 March 2018‎ Planetoid talk contribs‎ m 17,266 bytes +160‎ →‎Error!: SQLSTATE[HY000]: General error undo
• curprev 16:0316:03, 9 March 2018‎ Planetoid talk contribs‎ m 17,106 bytes +49‎ →‎Error!: SQLSTATE[HY000]: General error undo
• curprev 14:3414:34, 9 March 2018‎ Planetoid talk contribs‎ 17,057 bytes +849‎ →‎ERROR 1045 (28000): Access denied for user 'user'@'localhost' (using password: YES) undo
• curprev 14:2314:23, 9 March 2018‎ Planetoid talk contribs‎ m 16,208 bytes +77‎ →‎Error!: SQLSTATE[HY000]: General error undo
• curprev 14:1614:16, 9 March 2018‎ Planetoid talk contribs‎ 16,131 bytes +107‎ →‎Error!: SQLSTATE[HY000]: General error undo
• curprev 14:0314:03, 9 March 2018‎ Planetoid talk contribs‎ 16,024 bytes +558‎ →‎ERROR 1005 (HY000) at line xx: Can't create table 'TABLE_NAME' (errno: 28) undo

5 February 2018

• curprev 10:5210:52, 5 February 2018‎ Planetoid talk contribs‎ 15,466 bytes +169‎ →‎could not access the mysql log undo

1 February 2018

• curprev 10:3610:36, 1 February 2018‎ Planetoid talk contribs‎ 15,297 bytes +97‎ →‎ERROR 2003 (HY000): Can't connect to MySQL server on 'ip' undo

26 January 2018

• curprev 15:4915:49, 26 January 2018‎ Planetoid talk contribs‎ 15,200 bytes +352‎ + ERROR 1813 undo

24 January 2018

• curprev 12:2312:23, 24 January 2018‎ Planetoid talk contribs‎ 14,848 bytes +27‎ →‎ERROR 2003 (HY000): Can't connect to MySQL server on 'ip' undo
• curprev 12:2112:21, 24 January 2018‎ Planetoid talk contribs‎ 14,821 bytes +94‎ →‎ERROR 2003 (HY000): Can't connect to MySQL server on 'ip' undo
• curprev 12:1412:14, 24 January 2018‎ Planetoid talk contribs‎ 14,727 bytes +299‎ →‎ERROR 2003 (HY000): Can't connect to MySQL server on 'ip' undo
• curprev 10:5410:54, 24 January 2018‎ Planetoid talk contribs‎ 14,428 bytes +279‎ No edit summary undo

23 January 2018

• curprev 13:5613:56, 23 January 2018‎ Planetoid talk contribs‎ m 14,149 bytes +222‎ →‎ERROR 2003 (HY000): Can't connect to MySQL server on 'IP' (116 "Connection timed out") undo
• curprev 11:2611:26, 23 January 2018‎ Planetoid talk contribs‎ m 13,927 bytes −95‎ No edit summary undo
• curprev 11:2511:25, 23 January 2018‎ Planetoid talk contribs‎ 14,022 bytes +14,022‎ Created page with "=== Troubleshooting of MySQL errors === ==== command not found: mysqldump ==== # locate the mysqldump command #* {{kbd | key=<nowiki>sudo find / -iname mysqldump</nowiki>}} fo..."