Questions tagged [mysql]
MySQL 8.0 is End Of Life on April 30, 2025. MySQL is an open-source database owned by Oracle. ServerFault topics include how to run the server. For more MySQL specific questions like backup/restore/recovery/configuration, dba.stackexchange.com is probably a better home.
8,803 questions
3 votes
0 answers
108 views
Migration of dictionary configuration with message's count and storage limits (plugin: quota/quota-imap) in mysql/mariadb - backend
I'm having a major problem converting my Dovecot configuration file to version 2.4.x. What I'm struggling with is using a dictionary to handle quotas within the MySQL backend (dict - plugin - Dovecot)....
- 31
1 vote
1 answer
110 views
mariabackup --prepare keeps backup state at "log-applied", not "full-prepared"
I'm performing a full backup on a MariaDB 10.6.8 instance on linux and encountering an issue where the --prepare step finishes successfully but fails to transition the backup state to full-prepared. ...
- 21
1 vote
0 answers
96 views
Is mariadb-secure-installation still relevant?
I just installed MariaDB on a brand new Ubuntu 24.04 LTS server, and most online configuration tutorials suggest I run mariadb-secure-installation right after installation, otherwise my database ...
- 66
1 vote
0 answers
97 views
server's temporary partition being in read-only mode
I’m running a WHM server and need to create a backup. However, my server administrator informed me that some files on the server are corrupted. I also have a very large MySQL database (around 450 GB). ...
- 111
0 votes
0 answers
312 views
Upgrading mysql to from 8.0 to 8.4 failed
I've an old server on Ubuntu 20.4 which is at EOL and just upgraded to Ubuntu 24 LTS via do-release-upgrade. I'm trying to upgrade all the current packages from focal(20) to noble(24) and was able to ...
-1 votes
1 answer
122 views
SSL error: Unable to get private key from '/etc/mysql-ssl/server-key.pem' after Debian 9 (stretch) to 10 (buster) upgrade
Upgraded Debian Linux 9 (stretch) to 10 (buster). Now I get the following error: SSL error: Unable to get private key from '/etc/mysql-ssl/server-key.pem' The detailed status message is: systemctl ...
- 402
1 vote
1 answer
93 views
How to map per-user quota with Dovecot quota plugin using MYSQL dict?
Problem: doveadm quota get -u <username> result shows that my MYSQL dict is not correctly mapped to Dovecot quota plugin, as a result IMAP QUOTA capability (with usage and limit) not being ...
- 11
0 votes
0 answers
76 views
MySQL repository HTTP connections failing from Oracle Linux
We have demo environments we build with Terraform and shell scripts. We are using an Oracle Linux 8.9 base image in Azure. Today the scripts started failing due to timeouts connecting to the MySQL ...
- 1
0 votes
1 answer
103 views
How to delete Mysql InnoDB table which won't start normally due to corrupted index
I'm trying to recover a mysql database. From the logs, I have this: 2025-06-06T11:29:52.627494Z 26 [ERROR] [MY-011853] [InnoDB] Corruption of an index tree: table `db`.`file_content` index `...
- 121
0 votes
1 answer
81 views
How can I connect a remote database server on SlickStack?
By default, SlickStack installs MySQL locally and connects WordPress to a localhost database. I want to skip that, and connect to a remote (managed) database server instead... What is the proper way ...
- 388
0 votes
2 answers
73 views
mysql replication 1236 requested master to start replication from impossible position
After a power outage on the master mysql server the replication does not want to start: mysql> show slave status\G *************************** 1. row *************************** ...
- 114
0 votes
0 answers
33 views
IMAP clients don't see mail: Postfix delivers in a different path from the one read by Dovecot (SQL Backend)
I'm setting up a business mail server on Ubuntu 22.04, following the LinuxBabe reference guide : https://www.linuxbabe.com/mail-server/setup-basic-postfix-mail-sever-ubuntu ✅ Stack technique : ...
0 votes
2 answers
127 views
How can I get the IP address of a failed mysql connection?
I have a remote mysql server that I want to connect to. I added my local IP address to ufw and am able to connect to the remote mysql server from my local machine. However, when I try to connect to ...
- 570
0 votes
1 answer
125 views
What are you planning to do when MySQL 8.0 goes end of life?
It seems a lot of people were running MySQL 5.7 for many years until it went end-of-life last year, and many have been on MySQL 8.0 series since 2019 which is going end-of-life next. What are people ...
- 1,059
0 votes
2 answers
474 views
How can I resolve mbind: Operation not permitted in MySQL/Percona XtraDB containers on Kubernetes when all capabilities are dropped?
I’m running MySQL (and Percona XtraDB) in Kubernetes under a very restrictive securityContext: securityContext: allowPrivilegeEscalation: false # no new privileges capabilities: drop: ...
0 votes
1 answer
90 views
Fake MySQL User being referenced by Serverl
I am getting an invalid user error message trying to connect to remote MySQL server. The user name is marcia@goddess. The marcia is okay but I can’t figure out where goddess is coming from. Goddess is ...
0 votes
1 answer
53 views
how to get mysql ReplicaSet status through mysql shell running in docker
I want to run a shell script to get mysql ReplicaSet status from mysql shell. Here is the cmd I use: docker exec -it mysqlsh mysqlsh --uri [email protected] -p111111 -e "dba.getReplicaSet().status()&...
- 1
0 votes
0 answers
87 views
Restore MySQL DB with only .frm and .ibd files
I had a WordPress site built in xampp and my machine crashed. I was able to recover the htdocs and database folder for the website. The DB folder has all the .frm/.ibd files along, with a .opt file. ...
0 votes
0 answers
72 views
Xampp Dtata Base 1932 error
So this is the situation. I had xampp on my work computer. I was building a new website and the machine crashed. We were able to recover the main DB which has both the .frm and .ibd files. We also ...
0 votes
0 answers
100 views
I want to easily use terraform to replicate with azuremysql
Sorry. I have a question. I tried to set up replication with azuresql using Terraform, but it cost me 800 yen. I want to do it cheaper, but what should I do? The sku_name is "GP_Standard_D2ds_v4&...
- 15
0 votes
0 answers
72 views
How to prevent mysql router fail on start if primary db is down?
I built a mysql replica set with one primary and one backup, and try to start mysql router. I found that if I stop the primary db, mysql router will refuse to start. Here is the error: Fetching ...
- 1
0 votes
1 answer
73 views
Can't connect to mysql by tcp immediately after a fresh installation
I installed mysql in a docker container called 'my'. Every time after the installation of mysql, I use this cmd to connect to mysql immediately: docker exec -it my mysql -uroot And it is ok. Then I ...
- 1
0 votes
0 answers
113 views
Get database error after installing Roundcube on Ubuntu 24.04
I am attempting to install Roundcube on Ubuntu server 24.04. I have followed this tutorial on YouTube: https://www.youtube.com/watch?v=Ntt86IEwuCE Everything went very well until the very last step, ...
- 101
0 votes
1 answer
208 views
MySql connection times out
MySQL sometimes takes a lot of time to connect, more than 10 seconds. Then I've got a connection timeout error. This does not occur in every attempt. In one minute it occurs several times. I have ...
- 1
2 votes
1 answer
161 views
MySQL Large database export and re-build in dev environment
I have a production database cluster (innodb if it matters) that has to be regularly backed up and imported into a development environment. Currently I am using a basic mysqldump to generate a *.sql ...
- 121
0 votes
0 answers
44 views
Unable to login as any user other than the root user after initializing MySQL RDS using terraform
I created a MySQL database in AWS RDS and added a new user using the following terraform script: resource "mysql_user" "user" { host = var.db_host user ...
- 155
1 vote
0 answers
69 views
ssh MySql query from Windows command line returns MySql usage information
From a Windows command line I am connecting via OpenSSH to a remote server to run a MySql query and save the output to a file Here are the iterations of the command I have attempted. ssh [email protected] ...
- 11
0 votes
0 answers
54 views
MySQL client was working, suddenly getting ERROR 2003 (HY000): Can't connect to MySQL server on X
I have 2 systems that connect to a remote MySQL. One of the systems suddenly stopped connecting. I'm not sure where to start tracking the problem with the client's connection. There are no answers ...
- 101
0 votes
2 answers
506 views
One-Way TLS in MariaDB certificate fails validation
I have MariaDB 10.11 on RedHat 8.10. I activated One-Way TLS on the server for test. I used the following tutorial: https://mariadb.com/kb/en/securing-connections-for-client-and-server/ : Set the ...
- 109
1 vote
0 answers
308 views
MariaDB startup warning "io_uring_queue_init() failed with errno 0"
I have a mariadb 11 docker container running with the folowing podman(!)-compose configuration: photoprism-db: container_name: photoprism-db hostname: photoprism-db image: mariadb:11 ...
- 111
0 votes
0 answers
73 views
Issues apt upgrade - Stalled on preconfiguring packages
I have a VPS running Ubuntu 20.04 LTS (I know i don't have long to upgrade it), I've just done a simple apt upgrade and now i believe it is stuck on "Preconfiguring Packagies". I've opened ...
- 175
0 votes
0 answers
40 views
what's the meaning of hostgroup_id explanation for proxysql
At: https://proxysql.com/documentation/ProxySQL-Configuration/ The proxy sql instructions say: NOTE: The backend MySQL servers have read_only = 1 configured on all replicas. ProxySQL considers backend ...
0 votes
1 answer
376 views
always needing innodb_force_recovery = 6
After many attempts I was able to restart a badly corrupted db by adding innodb_force_recovery = 6 to my.ini However now, I am unable to start the server at all unless that line is permanently in the ...
- 209
0 votes
1 answer
222 views
Mysql 8 on Windows: any change to my.ini breaks the startup sequence
Mysql 8.0.41 on Windows (but this applies to previous versions too, at least all the 8.x versions) I can stop and restart the service from task manager/services as many times as I want, no problems. ...
- 209
0 votes
0 answers
209 views
Error: MySQL shutdown unexpectedly
First Check MySQL Error Log I went to the "data" directory in the mysql database I renamed the "data" folder to "data-old" and created another folder named "data&...
0 votes
0 answers
200 views
Failed to start MySQL Community Server on Ubuntu
I'm running apache and mysql on Ubuntu. The server recently ran out of space on the main partition and mysql failed to start as a result. This has happened before and has been an easy fix (increase ...
- 101
0 votes
1 answer
109 views
My test database disappeared after committing MySQL docker container
I run MySQL in a docker container: sudo docker run --rm --name mysql5 --net legacy_net --net-alias mysql5 --ip 172.20.0.2 -e MYSQL_ROOT_PASSWORD=$MROOTPASS -d mysql:5.7 mysql -u root -h 172.20.0.2 -p$...
- 111
0 votes
1 answer
116 views
MySQL8 uses huge amount of the disk space
I migrated 3 of my 11 databases from MySQL 5.7.44 on Ubuntu 16.04 to MySQL 8.0.40 on Ubuntu 24.04. The space used on my old machine: root@localhost:/var/lib/mysql# du -ha --max-depth=1 19M ./bot 4....
- 111
0 votes
1 answer
655 views
Ubuntu 22.04 - Install MySQL 5.7 - Automate Script
I'm working on a legacy platform that we're automating the deploy. It will require multiple iterations until it gets to the point that we use in production. Right now, I'm in the step of setting up ...
- 125
0 votes
2 answers
202 views
MySQL 5.7 Why can I connect to source but not replicate?
I am trying to set up replication between two mysql 5.7 servers. I am able to connect to the source from the replica, but when I try to start replication, the replica fails to connect to the source. ...
- 101
0 votes
0 answers
150 views
MySQL GSSAPI Authentication Failing with "Access Denied" Error
All obfuscated portions are noted in [brackets]. I have MySQL set up on Rocky Linux v9.5 with MySQL Enterprise v9.1.0-1.1el9. Using a trial version of MySQL Enterprise Edition, I am trying to get the ...
0 votes
0 answers
27k views
MySQL error [Warning] Aborted connection ... to db: ... (Got an error reading communication packets)
I am getting this error on my MySQL logs. 2025-01-01 9:02:42 8090 [Warning] Aborted connection 8090 to db: 'xxx' user: 'xxx' host: 'xxx' (Got an error reading communication packets) Also, I am ...
0 votes
2 answers
350 views
service mysql restart sometimes sends ubuntu load average to over 200, and it doesn't go down
I have an app that seems to grab excess mysql connections (8.0.40-0ubuntu0.24.04.1), to reset i use "service mysql restart", but one time in 10 the processor load average going above 200 and ...
- 239
0 votes
0 answers
377 views
Export and import database in UTF8
I'm migrating a Moodle server in Spanish. I need use tick marks. I have export and import database. mysqldump --default-character-set=utf8mb4 -u root -p moodle > moodle.sql mysql -u root -p --...
- 3
0 votes
0 answers
85 views
MySQL table_open_cache miss 100% on query spikes
We encountered a situation where we had multiple connections opened to our DB, which seems to cause a high rate of open table cache misses. I would expect that in this kind of situation we see 100% ...
- 101
0 votes
1 answer
144 views
mariadb(or mysql) docker container use usb drive dir as volume
Following it's my test code version: '3.8' services: mariadb: image: mariadb:10.6 container_name: test-mysql restart: always command: --transaction-isolation=READ-COMMITTED --log-bin=...
- 101
0 votes
1 answer
987 views
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
Suddenly after restarting the machine, I have been facing this error can't connect to MySQL server and table plus is not able to connect with localhost 127.0.0.1. The steps below worked for me, and ...
0 votes
2 answers
340 views
How to connect to MariaDB Server via OpenVPN
My problem is probably super trivial, but I'm really completely new to these topics. I have a virtual server (Ubuntu 24.04, Plesk) with a fixed IP (123.123.123.123 in the example) with my provider ...
0 votes
1 answer
72 views
MySQL queries executed with the wrong user
I am connecting to MySQL with user 'feedbackdev', but the queries are executed with 'feedback', which is another user on the same server. root@board:~# mysql -u feedbackdev -p feedbackdev Enter ...
- 265
0 votes
0 answers
49 views
Issues with SSL Authentication Using Multiple Certificates in MySQL Client (MySQL Java Connector)
I'm working with two MySQL servers, both of which are authenticated using SSL. On the client side, I have successfully connected to the first MySQL server after adding one certificate to the keystore. ...
