Topics tagged mysql

Topic	Replies	Views	Activity
How do I fix «The user specified as a definer ('<user>'@'%') does not exist»? MySQL mysql , bash , sed , text-processing , unix	3	993	August 30, 2025
Investigating MySQL latency in Node.js Node.js php , networking , nodejs , unix , mysql , unix-socket , upwork-portfolio	1	18	June 10, 2025
How to fix external network connections to MySQL on CentOS? MySQL networking , centos , mysql	1	28	February 12, 2025
How to execute `ALTER` for a MySQL table without locking it? MySQL mysql	1	16	February 12, 2025
How do I drop tables in a MySQL database based on a name pattern? MySQL mysql , sql	1	20	October 8, 2024
How did I fix «mysqldump: Got error: 145: Table '<…>' is marked as crashed and should be repaired when using LOCK TABLES»? MySQL mysql	1	5	August 18, 2024
How do I fix «ERROR at line 1: Unknown command '\-'» on importing a MySQL dump back to a database? MySQL mysql , sql , sed , text-processing , grep	1	693	August 4, 2024
How did I prevent MySQL from shutting down once a day at the same time? MySQL mysql , ubuntu , unattended-upgrade , apt	2	14	August 3, 2024
How did I fix «[System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>» for MySQL in Ubuntu 22? MySQL ubuntu , ubuntu-22 , mysql , unattended-upgrade	1	327	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'»? MySQL authentication , password , mysql , mysql8	1	12	August 3, 2024
How did I switch MySQL to `caching_sha2_password` instead of `mysql_native_password`? MySQL password , mysql8 , mysql	1	13	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? MySQL ubuntu , ubuntu-22 , password , mysql8 , mysql	1	23	August 3, 2024
How to find the password of a non-root MySQL user? MySQL authentication , password , mysql	1	5	August 2, 2024
How do I list all MySQL users with their authentication methods? MySQL authentication , mysql , sql	1	6	August 2, 2024
How did I prevent MySQL failing on any `apt install <package>` command in Ubuntu 20? MySQL apt , ubuntu , ubuntu-20 , mysql	1	29	August 2, 2024
What is the maximum length of a `VARCHAR` column in MySQL? MySQL mysql	1	27	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? Debian apt , debian , debian-12-bookworm , mysql , no_pubkey , public-key-cryptography , gpg , public-key-certificate , apt-key	1	111	July 16, 2024
How did I fix «Error: 13 (Permission denied)» on MySQL start? MySQL filesystem , mysql	0	4	July 13, 2024
Why does MySQL fail to start with a custom `log_error` location? MySQL mysql , unix , app-armor , mysql-configuration-file	1	221	June 15, 2024
How did I fix «update-alternatives: error: alternative path /etc/mysql/mysql.cnf doesn't exist»? MySQL apt , mysql , mysql-configuration-file	1	203	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? MySQL ssl , tls , mysql , mysql8 , mysql-configuration-file	1	112	June 16, 2024
How to remove the «SSL context is not usable without certificate and private key» warning for a localhost-only MySQL server? MySQL mysql , networking , ssl , mysql-configuration-file	0	5299	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? MySQL mysql , mysql8 , mysql-configuration-file	1	212	June 16, 2024
How to fix the «Could not increase number of max_open_files to more than 1024» MySQL issue? MySQL mysql , open-files-limit	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? MySQL mysql , mysql-configuration-file , filesystem , unix , ubuntu , ubuntu-20 , systemd	1	173	June 16, 2024
How did I fix «Status: "Server shutdown complete"» / «Error: 9 (Bad file descriptor)» in MySQL for a custom `log_error` location? MySQL mysql , mysql-configuration-file	1	232	June 15, 2024
How to reset an unknown `root` password in MySQL 8? MySQL mysql , mysqld_safe , mysql8	1	351	February 22, 2024
How did I fix «Plugin 'auth_socket' is not loaded» for MySQL? MySQL mysql , mysqld_safe	1	3253	February 22, 2024
How did I fix «Directory '/var/run/mysqld' for UNIX socket file don't exists» on `mysqld_safe`? MySQL mysql , mysqld_safe	1	1565	February 22, 2024
How do I stop `mysqld_safe`? MySQL mysql , mysqld_safe	1	477	February 22, 2024