Questions tagged as ['mysql']

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:

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

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

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

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

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.

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

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 with the domain, example to use example.com:3306 instead of xxx.xxx.xxx.xxx:3306 inside PHP code?

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

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
innodb_buffer_pool_instances=64
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=1
innodb_lock_wait_timeout=120
innodb_file_per_table=1


innodb_io_capacity=5000
innodb_write_io_threads=32
innodb_read_io_threads ...

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 : com.google.gwt.user.client.rpc.StatusCodeException: 500 The call failed on the server; see server log for details" popup.

Steps followed :

• Install a tomcat serve ...

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

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

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

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

https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html#innodb-data-encryption-master-key-rotation

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?

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: Package: perl-DBD-MySQL-4.013-3.el6.x86_64 (C6.10-base)
Requires: libmysqlclient.so.16(libmysqlclient_16)(64bit)

I searched for the file but i have libmysqlclient.so.18 instead of libmysqlclient.so.16

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

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.

Dockerfile:

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

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:

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.

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

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

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

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

1.my 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?

2.how can i made unique ovpn file for connect to all server that in cluster?

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-optimizer.cnf

[GLOBAL]
optimizer_switch='rowid_filter=off'

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

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

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

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

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

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

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

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

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'@'host.domain.com' IDENTIFIED BY 'something';

Does lo ...