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,802 questions
0
votes
1
answer
30
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
81
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
18
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
36
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
46
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
82
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
44
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
59
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
50
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
111
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
1
vote
1
answer
106
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 ...
- 111
0
votes
0
answers
21
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
48
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
40
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
155
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