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,753
questions
-1
votes
0
answers
10
views
How to monitor wordpress websites individually deployed on an apache2 server?
Since last few weeks there are sudden downs to my EC2 machine and none of the websites become accessible and also ssh to machine stops working. please help me fix it.
I have an EC2 machine where ...
0
votes
2
answers
3k
views
General error: 2006 MySQL server has gone away. All settings fine
I have 2 linux servers. 1 is running apache2 with an PHP application and the other one is running mysql 5.7. (so a remote connection to DB)
PHP applications tried to create a BIGBLOB from a file (90MB)...
1
vote
0
answers
16
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
3
answers
62
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 ...
0
votes
2
answers
71
views
MySQL Client taking more than 14 sec to be connected
IN our on-prem server we have installed mysql 4 node cluster 2 for mgmt and 2 for datanode. All are physical server with 1TB ram and 64 core processor. When a user trying to connect to mysql server ...
- 37.1k
0
votes
0
answers
20
views
Issues with host and PHP [closed]
I'm with TSOHOST who have been bought out by i believe GoDaddy. I've found out they have moved all of my sites onto their new hosting.
The issue im having is that the wp-admin part is working and i ...
- 165
1
vote
1
answer
2k
views
Error 13 when executing mysqldump to export a database into a cvs file
I would like to export my database into a .csv file but I got a problem when I execute the command to do that:
mysqldump -u root -p -t -T~/tesht/ database orders --fields-terminated-by=','
...
- 1
4
votes
1
answer
1k
views
MySQL (InnoDB) - processes waiting on futex
Currently troubleshooting a MySQL server spending a lot of time in futex syscalls. All databases are InnoDB and seeing high load on my 16 core machine, and slightly more than half of CPU time is in ...
1
vote
3
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 ...
- 11
9
votes
4
answers
6k
views
Check remote certificate - MySQL
I've found Save Remote SSL Certificate via Linux Command Line but in the case of MySQL (and thus TLS) it doesn't work.
So the question is - how do I check remote certificate for TLS connection to ...
- 11
1
vote
1
answer
42
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
104
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 ...
- 33.8k
4
votes
2
answers
5k
views
Large lag on mysql replication (Relay_Log_Pos and Exec_Master_Log_Pos does not increase)
Today my two slave's (one mysql 5.1 and second MariaDB 5.5, master is mysql 5.1) started lagging. Similar situation are quite often with lags rises to even 10000 seconds, because slaves have worse ...
CommunityBot
- 1
8
votes
1
answer
20k
views
Connect to remote MySQL using proxy
I'm trying to connect to a remote MySQL server (with TCP access limited to a specific IP) using port forwarding via SSH, but still haven't figured out how to do it.
Here's what I intend to do:
Local[A]...
- 4,607
3
votes
1
answer
7k
views
How to connect to remote MySQL server using Socks Proxy
I can only connect to a remote server from an specific IP address (Ubuntu Server), this was okay when I was at office but now that I'm working from home I'm stuck.
I have SSH access to the Ubuntu ...
- 4,607
0
votes
2
answers
7k
views
User with grant permissions cannot grant permissions for new user with and new database
I am using: mysql 5.5.43-0 on ubuntu 14.04.1
I try to create a new admin-user (admin) who is allowed to do the following things:
a creating new users (dbuser1) with password - (permission "create ...
CommunityBot
- 1
0
votes
0
answers
61
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
27
votes
3
answers
58k
views
How can I back up a table structure but NOT its data in MySQL
I am using MySQL Administrator for making my database backup. I can perfectly back up the whole database with all its tables. There are some tables whose size is very big so I wonder if I could only ...
- 194
4
votes
1
answer
8k
views
Multiple files found for the same tablespace ID
After a management over-sight, the hard disk utilization of the mysql server went to 100%. In panic, I shut down most of the services - including mysqld, which I guess caused this problem. ...
CommunityBot
- 1
0
votes
2
answers
49
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. ...
- 186
3
votes
1
answer
6k
views
mysql binlog error "ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 341, event_type: 2 **"
I am new in mysql binary log and replication .Please help me sort this issue.
I am using mysql version 5.0.95 and now facing errors in binlogs. Some of querries in binary log as unknown event and ...
CommunityBot
- 1
1
vote
2
answers
144
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 ...
- 521
0
votes
1
answer
466
views
Error 2003 is Occurring when connecting MYSql through SQL yog tool
I couldn't login to my MySQL database through SQLyog tool. The screen shot of the error is shown below and I can login to the database through SSH Secure Shell.
- 4,494
2
votes
4
answers
1k
views
MySQL keyring component (not plugin) not loading on server startup
Problem:
There is no indication mysqld is actually reading the server manifest and/or the keyring component configuration file. Any help would be greatly appreciated.
System Info:
Ubuntu 20.04
...
- 21
2
votes
2
answers
866
views
MySQL keyring component configuration
I am having the exact same issue as described by user nerdgeekdork here:
MySQL keyring component (not plugin) not loading on server startup
I have tried setting up the component in the same way, as ...
- 21
2
votes
3
answers
7k
views
How can I lower the CPU usage on MySQL queries?
We are running a Wowonder-based social site for a little community and as soon as we hit 100 users online, our site becomes extremely slow due to high CPU usage. The script itself should be fine ...
- 121
5
votes
4
answers
29k
views
MySQL Dump Viewer
I'm a linux user, however, I'm provided with a Windows laptop in the office. I could fire up a small web server with PHPmyadmin or even upload to a remote system and import into a database, however, ...
- 756
0
votes
1
answer
39
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
3
votes
1
answer
12k
views
Mysql cannot start - Could not find valid tablespace file for
My mysql service is currently unable to start with the error
InnoDB: Could not find a valid tablespace file for 'wowcher/temp_import'.
I think I know what the issue is. I have a PHP script which ...
CommunityBot
- 1
0
votes
1
answer
7k
views
can't set secure_file_priv on mysql 5.7 Ubuntu 16.04
How do I set a value for secure_file_priv?
I found this which tells what settings may be used
https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_secure_file_priv
The mysql ...
CommunityBot
- 1
0
votes
1
answer
50
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
4
answers
6k
views
Sometimes: Unable to connect to host 127.0.0.1, or the request timed out. MySQL through Sequel PRO
I have been struggling with this issue for over a year now, and it’s really giving me a headache.
I often experience I am unable to connect to the MySQL server through SequelPRO. If I ssh into the ...
CommunityBot
- 1
0
votes
1
answer
5k
views
MySQL Locking Up INNODB Tables
My environment is Windows 7 and I'm using XAMPP.
I was doing some performance testing on MySQL simulating adding 100 rows at a time. I was doing this using a simple PHP query with for loops.
However,...
CommunityBot
- 1
2
votes
1
answer
216
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
2
votes
3
answers
208
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
...
- 21
0
votes
0
answers
30
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
0
votes
2
answers
4k
views
Apache can't connect to remote MySQL, but mysql command line from same server can
Symptoms:
I am running CentOS 6.
I can connect to the remote MySQL from the command line: mysql -h a.b.c.d -u user -p -D db.
Laravel artisan commands run on the local command line can also connect: ...
0
votes
2
answers
57
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 ...
0
votes
2
answers
6k
views
Galera + MariaDB: Deadlock: wsrep aborted transaction
I have 1 server configured the galera, 4 servers with mariadb and 1 with haproxy.
But when I want to do an update on any server I get the error "Deadlock: wsrep aborted transaction" or "...
CommunityBot
- 1
1
vote
1
answer
108
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 ...
- 570
0
votes
1
answer
48
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 ...
- 2,618
0
votes
0
answers
94
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, ...
0
votes
1
answer
103
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 ...
- 101
0
votes
1
answer
5k
views
Error 'Character set '#255' is not a compiled character set and is not specified mySQL
Okay, I've hit a brick wall and have run out of ideas.
Master: 8.0.25-0ubuntu0.20.04.1
Slave: 5.7.33-0ubuntu0.16.04.1-log
Getting error with show slave status\G:
Last_SQL_Errno: 22
Last_SQL_Error:...
CommunityBot
- 1
1
vote
2
answers
5k
views
Can't allocate nodeid for API
I'm running a pretty minimal MySQL cluster with configuration pretty much taken straight from the documentation. The data nodes are connecting fine, but the management server refuses to accept the ...
CommunityBot
- 1
2
votes
1
answer
7k
views
disable ssl for mysql client apps
I have set up SSL for mysql replication. The problem is, that it makes problems on the other local apps which use mysql.
Like postfix:
Jul 25 23:00:22 srv1 postfix/proxymap[3141]: warning: connect ...
CommunityBot
- 1
1
vote
0
answers
25
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 ...
- 11
3
votes
2
answers
27k
views
MySQL failed to start. Error 1053. Windows Server 2008 R2
I did a server restart for my web server and on restart, MySQL won't start.
If I use taskmanager to kill mysqld.exe and try the start from services console, it gets about 50% through the startup, ...
0
votes
1
answer
75
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 ...
- 22.7k
0
votes
0
answers
144
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
...
