Skip to main content
Server Fault

Questions tagged [mysql]

Ask Question

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,804 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
0 answers
30 views

I developed a system with Spring Boot (backend), Angular (frontend), and MySQL. I want to deploy it on an OVHcloud. Any step-by-step guide or reference would be appreciated.
MAIL MAIL's user avatar
  • 1
0 votes
1 answer
140 views

We are running mariadb: Server version: 10.5.27-MariaDB-log MariaDB Server and we need to backup a database named sports and on restoration "rebuild" all its indexes. For mysql AI suggest to ...
Jose Cabrera Zuniga's user avatar
  • 317
3 votes
0 answers
139 views

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)....
Vacuum's user avatar
  • 31
1 vote
1 answer
126 views

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. ...
stander's user avatar
  • 21
1 vote
0 answers
169 views

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 ...
Karl Kubelet's user avatar
  • 76
1 vote
0 answers
100 views

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). ...
Aftab Amin's user avatar
  • 111
0 votes
0 answers
542 views

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 ...
user42124's user avatar
  • 1
-1 votes
1 answer
133 views

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 ...
klor's user avatar
  • 402
1 vote
1 answer
138 views

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 ...
Alan's user avatar
  • 11
0 votes
0 answers
86 views

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 ...
Leigh K's user avatar
  • 1
0 votes
1 answer
194 views

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 `...
brunoais's user avatar
  • 121
0 votes
1 answer
83 views

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 ...
Jesse Nickles's user avatar
  • 388
0 votes
2 answers
159 views

After a power outage on the master mysql server the replication does not want to start: mysql> show slave status\G *************************** 1. row *************************** ...
Arany Péter's user avatar
  • 114
0 votes
0 answers
37 views

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 : ...
osnetworking's user avatar
  • 1
0 votes
2 answers
142 views

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 ...
Citizen's user avatar
  • 570
0 votes
1 answer
134 views

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 ...
Otto's user avatar
  • 1,059
0 votes
2 answers
527 views

I’m running MySQL (and Percona XtraDB) in Kubernetes under a very restrictive securityContext: securityContext: allowPrivilegeEscalation: false # no new privileges capabilities: drop: ...
Neaj Morshad's user avatar
  • 1
0 votes
1 answer
93 views

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 ...
rickzipser's user avatar
  • 1
0 votes
1 answer
54 views

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()&...
Calvin_Z's user avatar
  • 1
0 votes
0 answers
91 views

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. ...
Kirk Sturgulewski's user avatar
  • 1
0 votes
0 answers
77 views

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 ...
Kirk Sturgulewski's user avatar
  • 1
0 votes
0 answers
104 views

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&...
GABAKU GIK's user avatar
  • 15
0 votes
0 answers
72 views

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 ...
Calvin_Z's user avatar
  • 1
0 votes
1 answer
80 views

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 ...
Calvin_Z's user avatar
  • 1
0 votes
0 answers
130 views

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, ...
KevinHJ's user avatar
  • 101
0 votes
1 answer
237 views

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 ...
Andrew M's user avatar
  • 1
2 votes
1 answer
170 views

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 ...
Zexelon's user avatar
  • 121
0 votes
0 answers
44 views

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 ...
jwir3's user avatar
  • 155
1 vote
0 answers
73 views

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] ...
Greg's user avatar
  • 11
0 votes
0 answers
54 views

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 ...
Ken Ingram's user avatar
  • 101
0 votes
2 answers
554 views

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 ...
TimLer's user avatar
  • 109
1 vote
0 answers
341 views

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 ...
eventhorizon's user avatar
  • 111
0 votes
0 answers
82 views

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 ...
Nathan's user avatar
  • 175
0 votes
0 answers
44 views

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 ...
Jose Cabrera Zuniga's user avatar
  • 317
0 votes
1 answer
430 views

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 ...
resle's user avatar
  • 209
0 votes
1 answer
262 views

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. ...
resle's user avatar
  • 209
0 votes
0 answers
226 views

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&...
Marouane Sadoune's user avatar
  • 1
0 votes
0 answers
215 views

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 ...
connersz's user avatar
  • 101
0 votes
1 answer
119 views

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$...
Dmitriano's user avatar
  • 121
0 votes
1 answer
119 views

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....
Dmitriano's user avatar
  • 121
0 votes
1 answer
739 views

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 ...
Jorge Mauricio's user avatar
  • 125
0 votes
2 answers
217 views

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. ...
elplatt's user avatar
  • 101
0 votes
0 answers
163 views

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 ...
cmatt4440's user avatar
  • 1
0 votes
0 answers
27k views

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 ...
Muratcan Dikmen's user avatar
  • 1
0 votes
2 answers
351 views

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 ...
Dr BDO Adams's user avatar
  • 239
0 votes
0 answers
404 views

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 --...
RAN55's user avatar
  • 3
0 votes
0 answers
85 views

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% ...
gCoh's user avatar
  • 101
0 votes
1 answer
146 views

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=...
chikadance's user avatar
  • 101
0 votes
1 answer
1k views

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 ...
Rizwan Ali's user avatar
  • 1
0 votes
2 answers
362 views

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 ...
Günther Ludwig's user avatar
  • 1

1
2 3 4 5
…
177