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,754
questions
0
votes
1
answer
46
views
MySQL upgrade from 80034 to 80035 "Still pending", so MySQL 80037 won't start
My "MySQL" instance on a dedicated server decided to update by itself. Automatic updates should be beneficial for security reasons, but in this case the Database collapsed.
A few months ago ...
- 1
0
votes
0
answers
16
views
mysqldump fails with max_allowed_packet set to highest possible value
I'm trying to take a mysqldump of a database with the following options:
mysqldump --single-transaction --set-gtid-purged=OFF -uuser -ppassword -t -q --compact dbname -hdb_host > data.sql
However ...
- 101
0
votes
0
answers
18
views
WSREP_SST: [ERROR] Possible timeout in receiving first data from donor in gtid stage
I have deployed Alma Linux 9 and MariaDB 10.11.7 with Galera 4 on two AWS instances and all the ports and firewall rules are open between 2 instances, I set the proper wsrep options and I am still ...
- 121
0
votes
1
answer
19
views
innodb_buffer_pool_size is not descreased
I use mysql 8.0.33 in docker.
volumes:
- ./sql:/docker-entrypoint-initdb.d
- ./store:/var/lib/mysql
- ./my.cnf:/etc/mysql/conf.d/mysqld.cnf
8 GB available RAM on server.
In my....
- 111
1
vote
0
answers
80
views
MySQL via SSH tunneling refuses user credentials
I initiate an SSH tunnel like so:
ssh -L 12345:127.0.0.1:51874 remote_server
Where 51874 is the port MySQL listens on (on the host, mapped to 3306 in a container) on remote_server. This works as ...
- 111
1
vote
2
answers
103
views
Rook Ceph storage and MySQL space very big difference
Can someone please advise me what could be the cause of this condition?
I have a Rook Ceph cluster on which MySQL database with 3x replication is stored. This database is used by me for development ...
- 123
1
vote
1
answer
62
views
phpMyAdmin Login Page Error: mysqli::real_connect(): Premature end of data in XAMPP
I'm encountering an error when logging in to phpMyAdmin on my local XAMPP setup. The login page displays the following errors:
mysqli::real_connect(): Premature end of data (mysqlnd_wireprotocol.c:387)...
- 11
0
votes
1
answer
110
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 ...
- 27
0
votes
0
answers
101
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 ...
- 1
0
votes
2
answers
51
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. ...
0
votes
1
answer
41
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....
- 101
0
votes
1
answer
68
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 ...
- 1
1
vote
2
answers
152
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 ...
- 11
2
votes
1
answer
238
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 ...
- 211
0
votes
0
answers
32
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 ...
- 1