|
How to find the largest tables of a MySQL database?
|
|
3
|
860
|
May 3, 2026
|
|
How do I fix «The user specified as a definer ('<user>'@'%') does not exist»?
|
|
3
|
994
|
August 30, 2025
|
|
How to fix external network connections to MySQL on CentOS?
|
|
1
|
32
|
February 12, 2025
|
|
How to execute `ALTER` for a MySQL table without locking it?
|
|
1
|
17
|
February 12, 2025
|
|
How do I drop tables in a MySQL database based on a name pattern?
|
|
1
|
22
|
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
|
7
|
August 18, 2024
|
|
How do I fix «ERROR at line 1: Unknown command '\-'» on importing a MySQL dump back to a database?
|
|
1
|
701
|
August 4, 2024
|
|
How did I prevent MySQL from shutting down once a day at the same time?
|
|
2
|
18
|
August 3, 2024
|
|
How did I fix «[System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>» for MySQL in Ubuntu 22?
|
|
1
|
336
|
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
|
16
|
August 3, 2024
|
|
How did I switch MySQL to `caching_sha2_password` instead of `mysql_native_password`?
|
|
1
|
19
|
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
|
32
|
August 3, 2024
|
|
How to find the password of a non-root MySQL user?
|
|
1
|
8
|
August 2, 2024
|
|
How do I list all MySQL users with their authentication methods?
|
|
1
|
7
|
August 2, 2024
|
|
How did I prevent MySQL failing on any `apt install <package>` command in Ubuntu 20?
|
|
1
|
36
|
August 2, 2024
|
|
What is the maximum length of a `VARCHAR` column in MySQL?
|
|
1
|
33
|
August 1, 2024
|
|
How did I fix «Error: 13 (Permission denied)» on MySQL start?
|
|
0
|
8
|
July 13, 2024
|
|
Why does MySQL fail to start with a custom `log_error` location?
|
|
1
|
231
|
June 15, 2024
|
|
How did I fix «update-alternatives: error: alternative path /etc/mysql/mysql.cnf doesn't exist»?
|
|
1
|
232
|
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
|
117
|
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
|
5300
|
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
|
221
|
June 16, 2024
|
|
How to fix the «Could not increase number of max_open_files to more than 1024» MySQL issue?
|
|
1
|
3479
|
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
|
179
|
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
|
244
|
June 15, 2024
|
|
How to reset an unknown `root` password in MySQL 8?
|
|
1
|
355
|
February 22, 2024
|
|
How did I fix «Plugin 'auth_socket' is not loaded» for MySQL?
|
|
1
|
3285
|
February 22, 2024
|
|
How did I fix «Directory '/var/run/mysqld' for UNIX socket file don't exists» on `mysqld_safe`?
|
|
1
|
1576
|
February 22, 2024
|
|
How do I stop `mysqld_safe`?
|
|
1
|
482
|
February 22, 2024
|
|
How did I fix «A mysqld process already exists» for `mysqld_safe`?
|
|
1
|
290
|
February 22, 2024
|