|
How do I drop tables in a MySQL database based on a name pattern?
|
|
1
|
2
|
October 8, 2024
|
|
How did I fix «mysqldump: Got error: 145: Table '<…>' is marked as crashed and should be repaired when using LOCK TABLES»?
|
|
1
|
1
|
August 18, 2024
|
|
How do I fix «ERROR at line 1: Unknown command '\-'» on importing a MySQL dump back to a database?
|
|
1
|
346
|
August 4, 2024
|
|
How did I prevent MySQL from shutting down once a day at the same time?
|
|
2
|
6
|
August 3, 2024
|
|
How did I fix «[System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>» for MySQL in Ubuntu 22?
|
|
1
|
141
|
August 3, 2024
|
|
How did I fix «Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'»?
|
|
1
|
8
|
August 3, 2024
|
|
How did I switch MySQL to `caching_sha2_password` instead of `mysql_native_password`?
|
|
1
|
7
|
August 3, 2024
|
|
How did I fix «ERROR 1819 (HY000): Your password does not satisfy the current policy requirements» MySQL error for the `debian-sys-maint` user in Ubuntu 22?
|
|
1
|
7
|
August 3, 2024
|
|
How to find the password of a non-root MySQL user?
|
|
1
|
3
|
August 2, 2024
|
|
How do I list all MySQL users with their authentication methods?
|
|
1
|
3
|
August 2, 2024
|
|
How did I prevent MySQL failing on any `apt install <package>` command in Ubuntu 20?
|
|
1
|
8
|
August 2, 2024
|
|
What is the maximum length of a `VARCHAR` column in MySQL?
|
|
1
|
5
|
August 1, 2024
|
|
How did I fix «Error: 13 (Permission denied)» on MySQL start?
|
|
0
|
2
|
July 13, 2024
|
|
Why does MySQL fail to start with a custom `log_error` location?
|
|
1
|
127
|
June 15, 2024
|
|
How did I fix «update-alternatives: error: alternative path /etc/mysql/mysql.cnf doesn't exist»?
|
|
1
|
123
|
June 16, 2024
|
|
How did I fix «[Warning] [MY-011068] [Server] The syntax '--ssl=off' is deprecated and will be removed in a future release. Please use --tls-version='' instead.» for MySQL 8?
|
|
1
|
91
|
June 16, 2024
|
|
How to remove the «SSL context is not usable without certificate and private key» warning for a localhost-only MySQL server?
|
|
0
|
5281
|
April 30, 2017
|
|
How did I fix «The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.» for MySQL 8?
|
|
1
|
153
|
June 16, 2024
|
|
How to fix the «Could not increase number of max_open_files to more than 1024» MySQL issue?
|
|
1
|
3429
|
June 16, 2024
|
|
How did I fix «[Warning] [MY-010140] [Server] Could not increase number of max_open_files to more than 10000 (request: 65535)» for MySQL in Ubuntu 20?
|
|
1
|
108
|
June 16, 2024
|
|
How did I fix «Status: "Server shutdown complete"» / «Error: 9 (Bad file descriptor)» in MySQL for a custom `log_error` location?
|
|
1
|
161
|
June 15, 2024
|
|
How to reset an unknown `root` password in MySQL 8?
|
|
1
|
315
|
February 22, 2024
|
|
How did I fix «Plugin 'auth_socket' is not loaded» for MySQL?
|
|
1
|
2228
|
February 22, 2024
|
|
How did I fix «Directory '/var/run/mysqld' for UNIX socket file don't exists» on `mysqld_safe`?
|
|
1
|
1206
|
February 22, 2024
|
|
How do I stop `mysqld_safe`?
|
|
1
|
384
|
February 22, 2024
|
|
How did I fix «A mysqld process already exists» for `mysqld_safe`?
|
|
1
|
277
|
February 22, 2024
|
|
How to paste a tab-formatted SQL command into MySQL shell?
|
|
1
|
238
|
February 9, 2024
|
|
How to disable the «automatic rehashing» feature of `mysql` by default?
|
|
1
|
161
|
February 9, 2024
|
|
How to resolve the «TIMESTAMP with implicit DEFAULT value is deprecated» MySQL warning?
|
|
0
|
1655
|
April 29, 2017
|
|
How to resolve the «'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' "sql modes should be used with strict mode» MySQL warning?
|
|
0
|
9564
|
April 29, 2017
|