|
How to find the largest tables of a MySQL database?
|
|
3
|
892
|
May 3, 2026
|
|
How do I fix «The user specified as a definer ('<user>'@'%') does not exist»?
|
|
3
|
1008
|
August 30, 2025
|
|
How to fix external network connections to MySQL on CentOS?
|
|
1
|
50
|
February 12, 2025
|
|
How to execute `ALTER` for a MySQL table without locking it?
|
|
1
|
31
|
February 12, 2025
|
|
How do I drop tables in a MySQL database based on a name pattern?
|
|
1
|
36
|
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
|
16
|
August 18, 2024
|
|
How do I fix «ERROR at line 1: Unknown command '\-'» on importing a MySQL dump back to a database?
|
|
1
|
758
|
August 4, 2024
|
|
How did I prevent MySQL from shutting down once a day at the same time?
|
|
2
|
27
|
August 3, 2024
|
|
How did I fix «[System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>» for MySQL in Ubuntu 22?
|
|
1
|
364
|
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
|
24
|
August 3, 2024
|
|
How did I switch MySQL to `caching_sha2_password` instead of `mysql_native_password`?
|
|
1
|
41
|
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
|
54
|
August 3, 2024
|
|
How to find the password of a non-root MySQL user?
|
|
1
|
18
|
August 2, 2024
|
|
How do I list all MySQL users with their authentication methods?
|
|
1
|
15
|
August 2, 2024
|
|
How did I prevent MySQL failing on any `apt install <package>` command in Ubuntu 20?
|
|
1
|
139
|
August 2, 2024
|
|
What is the maximum length of a `VARCHAR` column in MySQL?
|
|
1
|
49
|
August 1, 2024
|
|
How did I fix «Error: 13 (Permission denied)» on MySQL start?
|
|
0
|
13
|
July 13, 2024
|
|
Why does MySQL fail to start with a custom `log_error` location?
|
|
1
|
248
|
June 15, 2024
|
|
How did I fix «update-alternatives: error: alternative path /etc/mysql/mysql.cnf doesn't exist»?
|
|
1
|
251
|
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
|
124
|
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
|
5306
|
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
|
233
|
June 16, 2024
|
|
How to fix the «Could not increase number of max_open_files to more than 1024» MySQL issue?
|
|
1
|
3489
|
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
|
194
|
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
|
266
|
June 15, 2024
|
|
How to reset an unknown `root` password in MySQL 8?
|
|
1
|
382
|
February 22, 2024
|
|
How did I fix «Plugin 'auth_socket' is not loaded» for MySQL?
|
|
1
|
3429
|
February 22, 2024
|
|
How did I fix «Directory '/var/run/mysqld' for UNIX socket file don't exists» on `mysqld_safe`?
|
|
1
|
1613
|
February 22, 2024
|
|
How do I stop `mysqld_safe`?
|
|
1
|
492
|
February 22, 2024
|
|
How did I fix «A mysqld process already exists» for `mysqld_safe`?
|
|
1
|
294
|
February 22, 2024
|