Skip to main content

Questions tagged [mysql]

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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
12 views

How to exclude `user` column from output of `ps`?

I want to get info about running processes and pass output to script. I have line shows the running MariaDB instance but its user is mysql. Is there a way to get all of ps waxfu output excluding ...
palmasd1's user avatar
0 votes
0 answers
17 views

Fatal error: Uncaught Error: Call to undefined function mysqli_connect() on Debian 12.5 with Apache2

I am trying to run my server with php 8.2 but it can't connect to my MariaDB database with mysqli. I have extension=mysqli in my php.ini When I do php -m | grep mysqli I get this: % php -m | grep ...
aaaaa's user avatar
  • 1
0 votes
2 answers
43 views

How to deal with legacy clients (hardcoded IP) after server migration

I am currently preparing the migration of a mysql server to another infrastructure with a new IP. After migration the old server will be shut down. Everything seems to work so far with the new server. ...
Marc Fischer's user avatar
0 votes
1 answer
36 views

Mariadb - MySQL server has gone away after 1 second of sleep

I'm receiving errors from Mariadb. This is ok: $db = new mysqli(...); usleep(1000*1000); // 1 second is ok $db->query('SELECT 1'); This is not ok: $db = new mysqli(...); usleep(1001*1000); // 1....
rooobertek's user avatar
0 votes
1 answer
38 views

Kubernetes MySQL Operator 8.4.0 not ready (stuck on start)

I have followed step by step the instructions to deploy the MySQL operator on Kubernetes. Following the instructions from the official page. Once deployed without errors, the operator is not in ready ...
dlbmusic's user avatar
1 vote
2 answers
124 views

How to debug 'Access denied' error for MySQL?

I am running a MySQL server (v14.14) on an Apple desktop on my LAN. I can access it from localhost and via a laptop, from a MySQL client. I'm now trying to add access from another client machine and ...
Mike Levin's user avatar
2 votes
1 answer
200 views

Can't start MariaDB after replacing 5.6 with 10.4

I have an old VM I use for dev testing - it runs CentOS 7.9 with nginx, PHP, and MariaDB. The MariaDB version was really old (5.6), but it was working well enough for me until today when I wanted to ...
OsakaWebbie's user avatar
0 votes
0 answers
26 views

Firefox generating two sessions in PHP

I am trying to record session ID's in Mysql database using PHP. In firefox, when I load a page, it records two different session ID's at the same time. However, in Chrome it only generates a single ...
Qamar's user avatar
  • 1
0 votes
2 answers
41 views

Not able to connect to MySQL from postfix

opensource community I am using Postfix, dovecot and Postfix Admin for my complete email setup I am using virtual users so I have installed postfix-mysql and dovecot-mysql Issue: My postfix service is ...
Sahil Pahuja's user avatar
2 votes
3 answers
190 views

Why is my Azure Database for MySQL slow at first

I created a SaaS product. I am using PHP 8.3 with a MySQL 8.0 database. Locally this is very fast! No frameworks etc are used. Production runs on Azure. I have the following setup on Azure: Database ...
Gerrit's user avatar
  • 21
0 votes
1 answer
40 views

Mysql filling up disk space, but storage not even on this disk

Have Mysql running on a server, with data, backups and logs each on their own disk. For 2nd time recently the root disk has filled up to 100% which gets cleared the moment that MySQL restarts. This ...
Mark Walker's user avatar
0 votes
0 answers
83 views

While creating the MySQL Operator for Kubernetes I faced CrashLoopBackOff on pods

I am trying to create a MySQL Operator for Kubernetes, using the guide of MySQL official documentation(https://dev.mysql.com/doc/mysql-operator/en/). While doing the steps mentioned in the Document, ...
Sivaparan Sivakajan's user avatar
0 votes
1 answer
83 views

MySQL Operator on Kubernetes Pods Stuck in Initializing State with "FailedBinding" Error

I'm trying to deploy MySQL InnoDB Cluster on Kubernetes using the Oracle MySQL Operator with the help of manifest files and kubectl. However, when executing the mycluster.yaml file, the pods are stuck ...
Tharsha Sivapalarajah's user avatar
1 vote
0 answers
23 views

Postfix accepting email from incorrect domain

I have a postfix setup and it appears to be accepting emails for other recepients and forwarding them to an existing legitimate email. For example, we receive a spam email for [email protected], and postfix ...
Shuttleu's user avatar
1 vote
1 answer
103 views

Why is MySQL service shutting down every day almost at the same time?

I read the log file to see if there is anything specific that triggers shut down, but couldn't find it. It happens at 1.30AM almost every day, And then I need to manually restart MySQL. There are ...
BenUK's user avatar
  • 11
0 votes
1 answer
71 views

Azure Wordpress Site Intermittent MySQL Issue

We are trying to figure out an issue where at least one of the Wordpress webserver IPs that Azure serves our site from cannot connect to our Azure MySQL database server The logs have continual ...
deflator's user avatar
0 votes
0 answers
96 views

Free disk space of Zabbix server is less than 20% on volume /var/lib

Zabbix server's /var/lib free disk space is running low. See the picture below https://i.sstatic.net/Jpbx7kl2.png Checking the server, the ibdata1 file is causing the problem. See the picture below ...
Khurel Bat's user avatar
0 votes
0 answers
29 views

How to remove a query from a MySQL master/slave setup that is causing the slave instance of MySQL to crash?

Specifically I have a query that is trying to grant privileges that for whatever reason is causing the slave MySQL instance to crash. As a result I can't even bring up the mysql console from the ...
user18969's user avatar
  • 113
0 votes
2 answers
60 views

MySQL database deleted on AWS EC2 instance [closed]

I have a AWS EC2 Windows instance with XAMPP and a database. To enable global access to the database, I made its IP global. Additionally, I added a password to my phpMyAdmin. However, someone is ...
Mustafa Ahmad's user avatar
2 votes
1 answer
161 views

mysql high CPU usage /usr/sbin/mariadbd

Our new VPS server for a wordpress website, have high CPU usage for mysql process, 50% CPU usage all the time. We don't have that many visitors and killing the process not working, there another new ...
Julash's user avatar
  • 21
0 votes
0 answers
13 views

Cannot create an open stack instance

I configure my environment with 2 controller 3 computer nodes in an OpenStack Wallaby Ubuntu 20.04.5 environment, and eventually I can't create an instance with an error when creating an instance on ...
김태웅's user avatar
0 votes
0 answers
24 views

fail2ban iptables REJECT rules not working [duplicate]

I managed to setup fail2ban and monitor my mysql database logs because I am being brute force attacked through my database login. the database is in a docker container and fail2ban is on the host ...
SirHectorin's user avatar
0 votes
0 answers
16 views

Entuity (monitoring SW) databse backup

If anyone is using quite obscure monitoring system named Entuity, I'm trying to find a good way of extending its database. Currently the system is using MySQL database. For some reason its setup to ...
J B's user avatar
  • 93
0 votes
1 answer
211 views

Permissions error in directories used by Docker and application I am developing

I have run a docker container mysql from my own application development on C#, and configured data persistence to this path: C:\ProgramData\Persistence\data\mysql When i start everything goes well ...
Francisco Nuñez IA Lover's user avatar
0 votes
0 answers
52 views

Enabling FIPS mode in MySQL Server 8.036+ on Windows

I'd like to enable the FIPS mode of my MySQL 8.0.36 community server instance running on Windows. I know the ssl_fips_mode option has been deprecated as of MySQL 8.0.34 but it should still work in ...
uwe's user avatar
  • 1
0 votes
2 answers
70 views

Wordpress and MySQL on same EC2 instance, different subnets. One public one Private

My goal is to have a single EC2 instance containing both WordPress and its MySQL database on same VPC and have the WordPress available on the public subnet and MySQL on the private subnet. The purpose ...
manoman687's user avatar
1 vote
1 answer
142 views

Mysql Stuck at "Server shutdown in progress" state

My MySQL was not responsive and I tried restarting the MySql server. Now for more than 2 hrs, it's stuck at the "Server shutdown in progress" stage. I need to bring the service back as soon ...
Enihr's user avatar
  • 111
1 vote
0 answers
160 views

Upgrading mysql - can not start server 8.0.35 => 8.0.36

After upgrading mysql the server can not start? Upgrade apt update && apt upgrade 8.0.35 => 8.0.36 OS: Debian bookworm error Tablespace 123588, name 'sys/sys_config', file './sys/...
clarkk's user avatar
  • 2,095
0 votes
0 answers
46 views

What causes SSD write timeout over 120 seconds?

system:CentOS Linux release 7.6.1810 (Core) kernel:Linux l-db11.tj.cn5 3.10.0-957.10.1.el7.x86_64 #1 SMP Mon Mar 18 15:06:45 UTC 2019 x86_64 x86_64 x86_64 GNU/Linux SSD:Dera cpu: 24 core memory: 128G ...
xianSheng Qian's user avatar
0 votes
1 answer
35 views

Loading data with new lines into MySQL fails [closed]

I'm loading data into a MySQL database. It is a shared calendar that is used with the baikal calendar. I dumped the DB, and vim checked it and I can see recent events. When I load the data into MySQL ...
gstlouis's user avatar
  • 119
0 votes
1 answer
620 views

How can I disable SSL (TLS) in MySQL 8.0.36+?

If I use tls-version='' in the config file, I'm getting the following warnings in the log: [Warning] [MY-013595] [Server] Failed to initialize TLS for channel: mysql_main. See below for the ...
Maxim Masiutin's user avatar
1 vote
1 answer
250 views

Low performance with mariabd and zabbix

I am having performance problems, with a mariadb database that I use for a Zabbix server, the MySQLTuner 2.5.3 error analyzer finds the following: could you advise me what values to set and in what ...
Dario Molfino's user avatar
-1 votes
1 answer
145 views

Mysql Error 1045 Access Denied: Using Password: FALSE

I'm using MySQL v8.0.35 with django and python. A website is used to access the database with both the website and database hosted on AWS. When the website tries to access the database in any way, it ...
Meep's user avatar
  • 1
0 votes
3 answers
269 views

Upgrade mysql 5.6 to 8 not working on AWS Linux based EC2

I am working with EC2 for MySQL DB. The OS of EC2 is AWS Linux-based Ubuntu. The current version of MySQL is 5.6.50. I am going to upgrade it to 8.0. I tried to upgrade it with this command: sudo yum ...
Cardoso's user avatar
  • 51
1 vote
0 answers
38 views

Python Flask application + MySQL DB -> needing advice for the infra in AWS when latency is at stake

I have a Python Flask application and a MySQL DB with which the app connects to. The app provides RESTful APIs. There are around 10 pairs of (Flask and MySQL DB)s. Each pair has a unique url and ...
Zhuang Paulus's user avatar
0 votes
1 answer
137 views

Why does MySQL server not respect bind_address?

Background I'm setting up a MySQL server. Its configuration file (my.cnf) does not have the bind_address option. As I understand from its documentation, its value defaults to *, which should make the ...
Christian's user avatar
  • 103
1 vote
0 answers
55 views

Using Clone for addInstance on MySQL Innodb Cluster uses 100% Memory

When trying to add a new node to a MySQL Innodb cluster using Cluster.addInstance() and selecting the Clone option, within 2 or 3 minutes the donor nodes memory usages hits 100% on a server with 36Gb ...
mwarble's user avatar
  • 11
0 votes
0 answers
118 views

MySQL `SELECT` query does not return the newest data

There are 3 servers: nginx server, fastapi server and mysql server. nginx server: web page on /admin/ fastapi server: api page on /api/select/ mysql server: stores the data (mysql version 8.3.0) /...
OrthoPole's user avatar
0 votes
0 answers
45 views

Mysql client using reverse DNS instead of IPv4 address when connecting to remote db [duplicate]

I have a server on Hetzner. When using the MySQL client to connect to a remote db from cli of that server, it returns the error: Access denied for user 'user'@'static.x.x.x.x.clients.your-server.de' (...
SYSTEMD's user avatar
1 vote
0 answers
191 views

Unable to connect to remote Dockerized MySQL container from local machine

I'm unable to connect remotely from my local machine, everything worked well but suddenly it won't let me to the mysql database anymore. I tried every possible combinations, but none of them worked ...
aspirinemaga's user avatar
1 vote
1 answer
293 views

Why did our AWS Aurora RDS spike and lock up?

This morning our aurora mysql serverless 2 spiked and basically locked up. We have a writer/reader and a reader associated with the cluster. On the reader we had an intense select query. This is the ...
Harpua's user avatar
  • 85
0 votes
0 answers
77 views

Kubernetes pods Can't connect to local MySQL server through socket

I have a problem with MariaDB (mysqld.sock) I have the next architecture: Deployment for APP1 Deployment for MariaDB1 PV11 and PVC11 (/var/lib/mysql/), PV12 and PVC12 (/run/mysql/) NFS1 server. ...
Bob's user avatar
  • 1
0 votes
0 answers
73 views

Can't access MySQL DB after failed import

Set off a mysql import which ultimately failed due to HD space being maxed out. Since then, I'm not able to drop either the table it was being loaded to or the DB the table belongs to (only one table ...
Chris's user avatar
  • 101
0 votes
0 answers
417 views

How to import ibd files into a new mysql 8.0 installation on windows (mysql.ibd is lost)

I have a mysql server and its default database is called mysql. Suddenly it stopped and I did not start it and it gives me this error. 2024-02-05T22:10:06.810728Z 1 [ERROR] [MY-012179] [InnoDB] Could ...
roma salah's user avatar
0 votes
1 answer
72 views

Is there a way to house one MySQL DB in one location and others in another?

Have any existing MySQL 8.0 server installation on a Ubuntu 22.04 machine. Existing works without issue, but looking to import a very large DB but doing so in its current data directory will max out ...
Chris's user avatar
  • 101
1 vote
1 answer
772 views

mysql bind-address change from 127.0.0.1 to server's IP Address breaks websites

I'm trying to setup mysql replica. On master when I change bind-address value in my.cnf to server's IP address some of websites break as they are using 127.0.0.1 as database host value. There are few ...
Vaughn's user avatar
  • 113
0 votes
0 answers
179 views

MariaDB Crashes on Startup with Let's Encrypt Certificates

It seems I'm encountering an issue while setting up secure connections for my clients to connect to my database server on Debian 12. Every time I attempt to start MariaDB, it crashes with a Private ...
sidboy55555's user avatar
0 votes
0 answers
15 views

xtrabackup - copying my.cnf file from source to replica when there are different linux distros on source and replica

https://docs.percona.com/percona-xtrabackup/innovation-release/set-up-replication.html#3-configure-the-sources-mysql-server 4. Configure the Replica’s MySQL server Copy the my.cnf file from the Source ...
Vaughn's user avatar
  • 113
0 votes
1 answer
135 views

Monit and MySQL/MariaDB Checksum

I have Monit monitoring MariaDB but when a minor MariaDB update is rolled out Monit fails to monitor as the Checksum has changed: Checksum failed Service mysql_bin Description: checksum failed, ...
neilgee's user avatar
  • 109
2 votes
3 answers
779 views

MariaDB using more memory than expected

We're running MariaDB server 10.6.16 from the RPM repository https://mirror.mariadb.org/yum/10.6/rhel9-amd64/ on a AlmaLinux 9.3 system with 48 GiB memory (no swap space) and 32 CPU cores. We're ...
stepping stone AG's user avatar

1
2 3 4 5
175