Questions tagged as ['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, is probably a better home.
Score: 0
Arnau Serra avatar
MySQL have_ssl and have_openssl DISABLED but certificates installed - Windows Server 2012
td flag

I want to enable an SSL certificate in MySQL Server for some users.

I tried following this tutorial - the one that is below Best Answer.

I installed OpenSSL, created all certificates and edited the my.ini. Then, after running SHOW global variables like '%ssl%'; I have the following result:

Variable_name Value
have_openssl DISABLED
have_ssl DISABLED
ssl_ca C:\mysqlCerts\ca-cert.pem
ssl ...
Score: 0
blankip avatar
How to tell which versions of TLS MYSQL (windows) is using?
pe flag

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. (I am not the person who set up the server builds - just trying to update it)

Anyway normally for mysql on apache I would add the following to make sure it wasn't using older TLS versions:

MinProtocol = TL ...
Score: 0
Bert avatar
Can I run a Select query on an SQL dump?
ng flag

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 month. They were created and everything, just outdated data. (no details, this is not the question) The question is: Is there a way to check if the sqldump really has the most up-to-date data in it? On an sql ...

Score: 1
Syed M. Sannan avatar
Keep MySQL strict mode disabled after server restart (Hostinger VPS with Ubuntu 18.04)
fr flag

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 globally the entire time for some parts of the site to work. For context, I am only managing the server end at the moment, so I cannot fix the parts of this site that require me to disable strict mode. Those f ...

Score: 2
Lars avatar
How to MySQL replicate or cluster to setup a failover scenario?
de flag

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 here.

I currently have server1 running two MySQL databases in separated docker containers. These should now be replicated on a second server. In case that server1 fails, I can switch to server2 rela ...

Score: 0
mona moghadampanah avatar
What does fragmented table mean in MySQL?
in flag

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 and what I have to do about it.

Score: 0
user8546041 avatar
Lost remote connection to MySql through DDNS addres to local server after installing IIS Windows Server 2012 R2
hm flag

I have a DDNS service that I use to connect to my local MySQL server when out of the office through my desktop app, everything was working fine until I installed IIS on the Server (Win Ser 2012 R2), I installed IIS because I also have a mobile app that connects to MySQL server through PHP and that one works fine through the DDNS connection. I am using VB on MS Visual Studio 2019, my connection string is ...

Score: 0
Nhân Trần avatar
Point domain to server without HTTPD
bb flag

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 ( to that machine, in order to access the MariaDB with the domain, example to use instead of inside PHP code?

How can I do that without to install the nginx/apache httpd?

Score: 1
linuxpro avatar
How to reduce MySQL Server CPU usage or load?
zw flag

How to reduce MySQL Server CPU usage or load ?

Here is my.cnf :




innodb_read_io_threads ...
Score: 1
Jaguards database configured incorrectly
in flag

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 the default credentials, or worse, a "checkDB error : 500 The call failed on the server; see server log for details" popup.

Steps followed :

  • Install a tomcat serve ...
Score: 0
Codemonkey avatar
Can't stop/restart MariaDB after a server ran out of disk space?
ml flag

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 had similar issues before and a systemctl restart mysql would normally fix it, but that just appears to hang, doing nothing for minutes on end. Same with systemctl stop mysql.

Should I assume it's doing s ...

Score: 0
daehnomel avatar
Problems with MySQL 8.0.29 Data Corruption, Need Upgrade Path Advice
gl flag

I have a master and 3 slaves running the buggy 8.0.29 version of MySQL. Yesterday 2 of my slaves stopped synchronizing and I couldn't complete a full resync from a fresh dump because I kept getting "error 2013 lost connection to SQL server" when reloading the dump file to either one of the downed slaves. I tried to resolve the error by editing my cnf file with various directives, that didn't work.N ...

Score: 0
Niek van der Steen avatar
MariaDB Master-Master replication with 3 servers, no ports open on master
sy flag

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 that this is called "master-master replication".

Now I do not want to open any ports on my 'real' master server, and only on the two 'slave' instances. Is it possible to have the 'real master' open the socket ...

Score: 0
iateadonut avatar
mysqldump encrypted table - keep encryption
th flag

If we have a table that is encrypted at rest, like this:

How can we configure mysqldump to dump encrypted data and the key in the tablespace, so that the sql file can only be successfully imported by a server that has a matching master key?

Score: 0
h0mayun avatar
Installing XtraBackup on Centos 6
km flag

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)
Error: Package: perl-DBD-MySQL-4.013-3.el6.x86_64 (C6.10-base)

I searched for the file but i have instead of

Score: 0
resle avatar
IIS FastCGI configuration for high concurrency
yt flag

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 1,000 users could be logged in concurrently (up to 10,000 in the near future). It doesn't seem to be an issue, until 100+ or so users log in concurrently, or near-concurrently.

I then get the server clogg ...

Score: 0
DevelJoe avatar
Getting a SQLSTATE[HY000] [2002] Connection refused in PHP Apache Docker container using mariadb, if connected via Dockerfile's CMD (PHP CLI works)
in flag

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 via PDO.


FROM php:8.1-apache

WORKDIR /var/www/html/

RUN pecl install xdebug \
    && apt update \
    && apt install libzip-dev -y \
    && docker-php-ext-enable x ...
Score: 2
Kiran Thummalapalli avatar
MariaDB - Contiunes to use more memory
cn flag

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 innodb_buffer_pool to 65 GB

Yet memory usage is as follows presently: enter image description here

And we continue to see swap continues to increase.

The server is dedicated to Mariadb and no other apps running on that other than Mariadb.

Score: 0
peter avatar
Warning - InnoDB: Page xxx in the doublewrite buffer is not within space bounds: page [page id: space=yyy, page number=zzz]
sa flag

I keep encountering this warning when the tablespace file mytable.ibd is over 4G bytes, then get the following error:

[ERROR] InnoDB: Trying to access page number xxx in space yyy, space name mydatabase/mytable, which is outside the tablespace bounds. Byte offset 0, len zzz, i/o type read. If you get this error at mysqld startup, please check that your my.cnf matches the ibdata files that you hav ...

Score: 0
Daniel Santos avatar
My GCP MySQL 8 CloudSQL Database, Randomly Restarts without a clue
co flag

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.

every time the instance is restarted we lost near 1 minute of uptime

Number of restart per day

I didn't find any error or relevant log for sql instance before it's restarts it self.

What I already did:

  • increase instance memory from 16 t ...
Score: 0
Behzad Soltaniyan avatar
openvpn access server cluster cannot create a unique ovpn file for all server
cg flag

i install multiple openvpn access server 2.11 on ubuntu 20 and install mysql for cluster it now i have 5 openvpn server in 1 cluster

openvpn_as 2.11 
ubuntu 20 problem is ovpn file that download from each server is different from other and i cant connect from 1 ovpn file to other server in same cluster? can i made unique ovpn file for connect to all server that in cluster?

Score: 0
Black avatar
Override MySQL Variable from conf file
id flag

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:


Restart services:

sudo service mariadb restart
sudo service mysql restart

Attempt #2:

Same as #1 but I moved my file here /etc/mysql/conf.d/70-optimize ...

Score: 0
Chris Strickland avatar
mysql -V shows a different version than mysqld -V
cn flag

I'm running centos 7 with mySQL 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 database. SELECT @@version in the client shows 5.7.11-4-log. The database acts like it is running the previous version (some differences in JSON functions, for instance).

Some background: when we started  ...

Score: 0
Klagor Mundavi avatar
phpmyadmin Mysql frozen in time
ar flag

i got a remote mysql database connection to work on my on ubuntu 22.04. I see on the website that i setup that data gets into the database as users are active in the website but when i check phpmyadmin the values in the database wont change, it's like it's frozen in time with the same values in the tables and rows that wont update in phpmyadmin itself.

I have had the website run for an hour now a ...

Score: 0
Rawkon avatar
Unable to Recover MySQL Database [Missing FILE_CHECKPOINT]
cn flag

Using MariaDB 10.7.3 via Homebrew on MacOS Monterey 12.6.1

While trying to recover the database after a system crash, I am stuck with the following situation.

[Note] mysqld (server 10.7.3-MariaDB) starting as process 41828 ...
[Warning] Setting lower_case_table_names=2 because file system for /opt/homebrew/var/mysql/ is case insensitive
[Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!
[Note] I ...
Score: 1
Rawkon avatar
MySQL Corrupted After System Crash
cn flag

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 local MySQL server through socket '/tmp/mysql.sock' (2)

Current results of "mysqld" command:

[Note] mysqld (server 10.8.3-MariaDB) starting as process 12300 ...
[Warning] Setting lower_case_table_names=2 because ...
Score: 0
CP3O avatar
What CLI tool helps rotate my mysqldump files on cloud storage: daily backups, weekly, and monthly backups with deletion?
in flag

I need to backup my mysqldump files from my database server, daily. I need to retain:

  • daily backups for a week
  • weekly backups for a month
  • monthly backups for a year
  • yearly backups after that

My preferred cloud storage is AWS S3.

My backups would run once every 12 hours, and then upload to cloud storage. After this, automatically I would need to delete backups that fall outside of the above retention ...

Score: 0
My Space avatar
mysql server failed when I run mysql.server start
tw flag

I use macOS Big Sur(11.5.1) and MariaDB(10.8.3_1) with Brew. After some manipulations with Docker(my guess) my mysql.server stopped working. I cannot run my local MySQL server.

These lines I have in the console when text command "mysql.server start"

Starting MariaDB
.221028 01:36:17 mysqld_safe Logging to '/usr/local/var/mysql/MacBook-Pro-My.local.err'.
221028 01:36:18 mysqld_safe Starting mariadbd da ...
Score: 2
Black avatar
Why can I use mysql even when entering a wrong password when using sudo?
id flag

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 get access.

Version: mysql Ver 15.1 Distrib 10.3.25-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

Score: 1
Victor Leal avatar
MariaDB 10.5 refusing remote connections
cn flag

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 remote connection. The database answers "Access Denied to user@host on database"

We created some users to test:

GRANT ALL PRIVILEGES ON db.* TO 'user'@'' IDENTIFIED BY 'something';

Does lo ...