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.
8,735
questions
0
votes
1
answer
152
views
Zabbix DB connection support DNS SRV Records
I have Zabbix Mysql 3 node Innodb cluster, which gives 3 DNS SRV Records with Mysql Router endpoints. I need to configure Zabbix server and web DB connection as DB host (e.g _mysql._tcp.example.com), ...
0
votes
0
answers
62
views
Can't login with a unique username into mysql
I am trying to connect a existing server files with my new machine. I need to be able to connect with a username "????", but for some reason mysql is not accepting that.
Using root as ...
1
vote
0
answers
902
views
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) docker
I have tried accessing the docker container mysql command line from outside of the docker container and from within. I am receiving the error above each time. I have also reset the docker container ...
0
votes
1
answer
804
views
"CrashLoopBackOff" while deploying mysql on multi-node cluster
This is my configmap.yaml file:
apiVersion: v1
kind: ConfigMap
metadata:
name: mysql
labels:
app: mysql
app.kubernetes.io/name: mysql
data:
primary.cnf: |
# Apply this config only ...
1
vote
1
answer
2k
views
Need to keep each binlog files to 24 hrs
We have a requirement werein we need to keep each binlog files(like mysql-bin-changelog.025249, mysql-bin-changelog.025250, mysql-bin-changelog.025251....) of MYSQL RDS to minimum 24 hrs.
However, i ...
0
votes
1
answer
100
views
When and How we should specify "clusterIP" inside the "service.yaml" file?
I tried to deploy mysql and cassandra databases using kubernetes.io/docs instructions. In both of them, within the service.yaml files, they use clusterIP: None like following:
For cassandra:
...
0
votes
0
answers
38
views
auto forward sender's email using mySQL to lookup up email address of recipient then send
Here is the scenario. Users of my web site can search for other users who live in the same vicinity. Match results display links which transfer match data to a send message page. The send msg page ...
0
votes
1
answer
106
views
Should I add a "MySQL_URI" to the MySQL Kubernetes deployment file?
This is a Kubernetes deployment file that originally was using only MongoDB database. I tried to add MySQL to it as well like below:
apiVersion: apps/v1
kind: Deployment
metadata:
name: auth-depl
...
0
votes
1
answer
67
views
How to start myslq if it fails to start due to insufficient space, and the main files eating up space are mysql binary log files
My server disk usage looks like this:
Filesystem Size Used Avail Use% Mounted on
udev 989M 0 989M 0% /dev
tmpfs 200M 21M 180M 11% /run
/dev/xda1 59G 57G ...
0
votes
2
answers
3k
views
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
EDIT: The following describes my original question, but as long as I haven't resolved the issue yet, I thought maybe I should change settings inside the created mysql POD instead of mysql config files ...
0
votes
2
answers
51
views
What database my applications will use if I have a locally installed database beside it's pod running on local Kubernetes?
I have installed mysql on my Ubuntu machine. I also have a locally running Kubernetes and deployed a mysql deployment on Kubernetes and can reach to that using kubectl exec -it mysql-b4769786-5hf4m sh ...
1
vote
1
answer
896
views
Dump a Table from MySQL Database directly from sql server using bash
How can I dump a table from a MySQL database using a bash script?
Like we can use the below command to dump a table
mysql -u username -p database_name > file.sql
But how can I dump only a single ...
0
votes
1
answer
320
views
Is it possible to manage read/write requests on AWS RDS?
We are planning to create a read replica on our MySql Database on RDS but we want to manage this on AWS. Does AWS has a solution that manages requests and redirect them if write to the master ...
0
votes
0
answers
276
views
MariaDB I/O Limit
I have a server with MariaDB 10.6.
The mysqld process uses 100% of DSK with very high I/O.
I tried to set these values but it didn't have any affect:
innodb_io_capacity = 100
innodb_io_capacity_max = ...
1
vote
2
answers
1k
views
Reset mysql user password using hashed password
On a mysql server, I made a mistake and changed the wrong user's password, like this:
SET PASSWORD FOR username@'10.1.%' = PASSWORD('newpassword');
Before changing the password, I used "SHOW ...
0
votes
0
answers
1k
views
debian 11 + mariadb remote connections
I'm having trouble getting mariadb to accept remote connections on Debian 11 on a fresh installation.
I've changed bind address to bind-address: 0.0.0.0. From the same server, I can telnet into port ...
0
votes
0
answers
123
views
Connecting postfix to mysql with ssl
I've been trying to get the correct recipe of settings to allow postfix to connect to mysql where ssl is required. So far I have the following config that is not working:
user = mysqluser
password = ...
0
votes
0
answers
609
views
MariaDB: Problems with UTF-8 characters after migrating to a new server
I have migrated to another server many times but never had this problem. None of the possible solutions work and utf-8 characters appear incorrectly in PHP-FPM.
What I tried:
ALTER DATABASE database2 ...
0
votes
1
answer
582
views
MySQL client 8.0 showing "fwrite: Broken pipe" on large query when using a pager
I have always been using a pager (--pager="less -SFX" to be more specific) for MySQL client. Previously I was on version 5.6 of MySQL client/server and it was doing great. Recently I ...
0
votes
1
answer
481
views
Unable to connect to server following phpMyAdmin upgrade from 5.1 to 5.2
Not sure to post on the right StackExchange forum. If not, let me know!
Working environment:
OpenSUSE Leap 15.4
MariaDB : mariadb Ver 15.1 Distrib 10.7.7-MariaDB
PHP 8.0.25 (cli) (built: Oct 31 2022 ...
1
vote
2
answers
2k
views
How do I securely connect to MySQL 8 when caching_sha2_password is in use?
I am moving from our web sites to a new host. Our database cluster (PCS) now runs MySQL 8. We have two database servers (active and failover) with a floating virtual IP that we connect to MySQL to.
We ...
0
votes
1
answer
284
views
How to tell which versions of TLS MYSQL (windows) is using?
I have another question about a pair of servers that I cannot turn off TLS 1.0/1.1. Even though IISCrypto showing them off and made right reg entries.
The servers run an IIS10/PHP7.4/MySQL8 stack. ...
0
votes
1
answer
673
views
Can I run a Select query on an SQL dump?
Here is my issue. I've a backup system, that creates an SQL Dump from a DB cluster every day. Works fine, yade yade. The cluster died one day and we realized, the sql dump were wrong for the past 1 ...
1
vote
1
answer
484
views
Keep MySQL strict mode disabled after server restart (Hostinger VPS with Ubuntu 18.04)
So I have a site hosted on VPS Hosting Plan 2 of Hostinger, and it uses MySQL for the database, with the OS of my Virtual Machine being Ubuntu 18.04.
I have to keep MySQL's strict mode disabled ...
2
votes
1
answer
532
views
How to MySQL replicate or cluster to setup a failover scenario?
after a massive data problem from my provider in GER, I'm now forced to deal with failover scenarios. But there are a few questions that I can't find any real answers to. So I hope someone can help me ...
0
votes
0
answers
92
views
What does fragmented table mean in MySQL?
I have a MariaDB database with an InnoDB engine and querying data take a lot of time so I search and found that it is maybe related to the tables being fragmented but I cannot understand what it means ...
0
votes
3
answers
52
views
Point domain to server without HTTPD
I have a VM on Oracle Cloud Free tier and have the dedicated IPv4. I installed MariaDB on this server.
I want to point the domain name (example.com) to that machine, in order to access the MariaDB ...
1
vote
1
answer
300
views
How to reduce MySQL Server CPU usage or load?
How to reduce MySQL Server CPU usage or load ?
Here is my.cnf :
skip-name-resolve
disable_log_bin
innodb_buffer_pool_size=200GB
innodb_log_file_size=25GB
innodb_log_buffer_size=8M
...
1
vote
1
answer
76
views
Jaguards database configured incorrectly
After following the steps given in the README of the open source tool provided by Jaguards, I always get the "Database configured incorrectly" warning icon, and can't manage to login with ...
0
votes
1
answer
2k
views
Can't stop/restart MariaDB after a server ran out of disk space?
Using CentOS Stream release 8.
I've made space, but my site still responds with Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] Connection refused in /var/www/sites/mysite/inc/DB.php
I've ...
0
votes
1
answer
336
views
MariaDB Master-Master replication with 3 servers, no ports open on master
I want three MariaDB database servers, one master and two "slaves". I want to be able to read and write on every server, and have this replicated on the other servers. I read on the internet ...
0
votes
0
answers
55
views
Installing XtraBackup on Centos 6
I’m trying to install XtraBackup on centos 6 using this guid but i get these errors:
Error: Package: perl-DBD-MySQL-4.013-3.el6.x86_64 (C6.10-base)
Requires: libmysqlclient.so.16()(64bit)
Error: ...
0
votes
0
answers
394
views
IIS FastCGI configuration for high concurrency
I am hosting, on Windows Server 2022, a web application that makes regular ajax calls to a PHP backend.
The calls themselves are quite light, just pulling and pushing data from and to a MySQL db.
Over ...
0
votes
1
answer
5k
views
Getting a SQLSTATE[HY000] [2002] Connection refused in PHP Apache Docker container using mariadb, if connected via Dockerfile's CMD (PHP CLI works)
I'm trying to run a Docker container based on:
PHP 8.1
Apache 2.4
MariaDB (latest official docker image)
It all starts up without any issue; but I'm unable to connect with the Docker Container's DB ...
2
votes
1
answer
180
views
MariaDB - Contiunes to use more memory
We are running Maria DB 10.6.9 on CentOS and we are observing it continues to increase the usage of memory.
Server Specifications:
RAM - 128 GB
vCPUs - 48
Swap - 100 GB
We have configured ...
0
votes
0
answers
139
views
My GCP MySQL 8 CloudSQL Database, Randomly Restarts without a clue
I using a mysql instance on cloud sql. However this instances began to restart the mysqld (mysql deamon) several times per day.
It was not due a change or anything, but just increasing like this.
...
0
votes
2
answers
807
views
Override MySQL Variable from conf file
I try to override the variable optimizer_switch and change rowid_filter=on to rowid_filter=off.
The official documentation does not provide an example.
Attempt #1:
/etc/mysql/mariadb.conf.d/70-...
0
votes
1
answer
87
views
mysql -V shows a different version than mysqld -V
I'm running centos 7 with mySQL 5.7.xxx. mysql -V shows Ver 14.14 Distrib 5.7.26-29, but mysqld -V shows Ver 5.7.11-4. systemctl status mysql and systemctl status mysqld both show the same running ...
1
vote
1
answer
574
views
MySQL Corrupted After System Crash
I'm using MacOS Monterey 12.6.1 with Homebrew 3.6.6 and MariaDB 10.8.3
The OS crashed out of nowhere and rebooted itself. After the reboot I was unable to connect to the database: Can't connect to ...
2
votes
1
answer
343
views
Why can I use mysql even when entering a wrong password when using sudo?
If I try to login to mysql with mysql -u root -p and enter the wrong password, then I get "access denied".
However, if I use sudo mysql -u root -p and enter the wrong mysql password, then I ...
1
vote
0
answers
718
views
MariaDB 10.5 refusing remote connections
I've gone through a lot of tutorials and questions and I still can't get it to work.
I installed MariaDB 10.5 on a Debian 11 server. We changed its IP address yesterday and since then we cannot do a ...
0
votes
1
answer
1k
views
socket doesn't exist; Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
I know the problem isn't new. But I have tried lots of thing. What I couldn't figure out is, socket wasn't available since I downloaded mysql.
/etc/my.cnf
/etc/mysql/my.cnf
/var/lib/mysql/my.cnf
None ...
0
votes
1
answer
357
views
cannot find mysql folder in /var/lib/mysql in rescue mode
I have I have a server fault. So I have boot to rescue mode and logged in using ssh as root. I have mounted all the disk and in fact I can see files, users etc. (I was using Vestacp as Control Panel). ...
0
votes
1
answer
60
views
does it benefit if split multiple sites into multiple database in shared hosting env?
I have been wondering this for long time
let's say I run a server where I hosted 2 PHP sites , they are both heavy on database query
server is multi-core , let's say 4 core 8 thread with bunch of RAM ...
1
vote
0
answers
145
views
How do I install latest iRedMail with existing Nginx
How to keep the current Nginx websites running intact when installing iRedMail?
0
votes
1
answer
279
views
Why only a few TCP packets arrive at destination on port 3306 through an IPsec VPN tunnel?
This question was off-topic on Networkengineering and the recommendation was to post it here. So, here we go...
When connected to a network via a VPN tunnel (IPsec/L2TP), I can normally access a MySQL ...
0
votes
1
answer
237
views
Promote to Master a MySQL slave that has its own slaves
MySQL standby & chained replication
Having the current setup (not using GTID) (see link to image):
PRODUCTION NODES: MASTER (A) -> SLAVE (A1) + SLAVE (A2)
STANDBY NODES: -> SLAVE (B) (with ...
2
votes
2
answers
914
views
Improving mysqltuner recommendations
Problem with mysql under Ubuntu 20.04.0 in a CPU optimized droplet of 32GB RAM with 16 cores.
I have 25 sites installed on this server. I have around 100k pages views daily and during peaks around 300 ...
2
votes
0
answers
382
views
Digital Ocean MysQL with high load average but no queries
My website is down because it cannot communicate with my MySQL database.
My database is inside the Digital Ocean server. My CPU, Load Average and memory is in the highest values right now:
Despite ...
0
votes
0
answers
113
views
Big performance gap between two similar servers in mysql-percona 5.6 ubuntu
I cannot figure out reason of performance difference between two (three?) similar percona 5.6 instances. I prepared some tpcc-like benchmarking using sysbench and among 3 similar servers, one is ...