|
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
|
196
|
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
|
122
|
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
|
7
|
August 3, 2024
|
|
How did I switch MySQL to `caching_sha2_password` instead of `mysql_native_password`?
|
|
1
|
5
|
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
|
6
|
August 2, 2024
|
|
What is the maximum length of a `VARCHAR` column in MySQL?
|
|
1
|
3
|
August 1, 2024
|
|
How did I fix «Err:3 http://repo.mysql.com/apt/debian buster InRelease The following signatures couldn't be verified because the public key is not available: NO_PUBKEY B7B3B788A8D3785C» on Debian 12?
|
|
1
|
34
|
July 16, 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
|
113
|
June 15, 2024
|
|
How did I fix «update-alternatives: error: alternative path /etc/mysql/mysql.cnf doesn't exist»?
|
|
1
|
118
|
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
|
82
|
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
|
5277
|
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
|
135
|
June 16, 2024
|
|
How to fix the «Could not increase number of max_open_files to more than 1024» MySQL issue?
|
|
1
|
3425
|
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
|
95
|
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
|
149
|
June 15, 2024
|
|
How to reset an unknown `root` password in MySQL 8?
|
|
1
|
307
|
February 22, 2024
|
|
How did I fix «Plugin 'auth_socket' is not loaded» for MySQL?
|
|
1
|
1905
|
February 22, 2024
|
|
How did I fix «Directory '/var/run/mysqld' for UNIX socket file don't exists» on `mysqld_safe`?
|
|
1
|
1076
|
February 22, 2024
|
|
How do I stop `mysqld_safe`?
|
|
1
|
347
|
February 22, 2024
|
|
How did I fix «A mysqld process already exists» for `mysqld_safe`?
|
|
1
|
275
|
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
|
159
|
February 9, 2024
|
|
How to resolve the «TIMESTAMP with implicit DEFAULT value is deprecated» MySQL warning?
|
|
0
|
1655
|
April 29, 2017
|