Questions tagged [mysql]
An open-source, relational database management system.
1,015 questions
3 votes
1 answer
105 views
How to configure multiple credentials in MariaDB for easy access?
I can't find this information. I also use Grok, but his solution didn't work. How can I add multiple accounts/credentials to different MySQL/MariaDB servers to be used with mysql command? Similar to ....
- 10.5k
1 vote
1 answer
67 views
Dependency issue attempting to install mysql-community-devel
sudo yum install mysql-community-devel Error: Package: libkadm5-1.15.1-50.el7.x86_64 (olbase) Requires: krb5-libs(x86-64) = 1.15.1-50.el7 Installed: krb5-libs-1.15.1-55.0.7....
1 vote
1 answer
146 views
mySQL failed to be set-up
I'm running Gentoo Linux and recently needed to install mySQL (older version). The compilation was successful, however setting up the server failed. I'm on this step: https://wiki.gentoo.org/wiki/...
- 253
0 votes
1 answer
119 views
Error installing package
In my CentOS Stream Linux 9 when I run the command: yum install perl-DBD-MySQL It gives me an error: Transaction Summary ===============================================================================...
0 votes
1 answer
104 views
Debian 12 APT Linux User invalid password settings
I tried installing the package "default-mysql-server" via apt. Like this sudo apt install default-mysql-server. While the install was running i got this error: Preparing to unpack .../...
- 1
0 votes
2 answers
1k views
What is the correct "mysql-client" package to install in Debian 12?
In Debian Desktop 12 if I want to do a remote connection as client to a MySQL Server in other machine in the LAN I need use the mysql command, when it is executed happens the following: manueljordan@...
- 2,206
0 votes
0 answers
251 views
Install mysql (not mariadb) on raspbian bookworm and other debian
There are many servers in the network that I manage, and throughout that network, mysql is the standard and only "mysql-like" database used. (There's some postgre but that is another matter)...
- 101
1 vote
1 answer
120 views
How I can allow my user to be connected via `localhost` when I ssh tunnel my Db connection?
In a server that I do not have admin access I managed to make an ssh tunnel as: ssh -N -L 33308:127.0.0.1:3306 [email protected] Then I attempt to connect into mysql via the tunnel: mysql -u testusr -...
- 1,331
0 votes
0 answers
233 views
single node Slurm machine, munge authentication problem
I'm in the process of setting up a singe-node Slurm workstation machine and I believe I followed the process closely and everything is working just fine. See below: sudo systemctl restart slurmdbd &...
- 387
0 votes
1 answer
98 views
Does a load of 41.20 (!?) suggest a hardware failure?
I have Ubuntu 24.04 on a Raspberry Pi 4 and after months of working fine, today it has jumped to a load 41 for no apparent reason. Can't connect to remote MySQL instance from the server. And gitlab ...
- 259
0 votes
0 answers
123 views
persistent - slurmdbd: error: mysql_query failed: 1193 Unknown system variable 'wsrep_on'
Hi I was working on installing Slurm and got most things sorted out but upon launching sudo journalctl -fu slurmdbd I get the following: Jan 25 12:49:49 ... systemd[1]: Stopped slurmdbd.service - ...
- 387
2 votes
1 answer
233 views
MySQL general_log.CSV is 47GB in Production – How to Free Space?
I’m managing a production MySQL server running on a VM, and I just discovered that the general_log.CSV file in /var/lib/mysql/mysql/ has grown to 47GB, consuming almost 70% of the disk space. Here’s ...
0 votes
0 answers
200 views
Install MySQL from their repository in Debian 11
I have updated Debian to 11. Mysql sources list still listed buster though. So i tried to reconfigure using mysql-apt-config_0.8.24-1_all.deb which did not help. So i downloaded mysql-apt-config_0.8....
- 675
0 votes
0 answers
35 views
How do I start the system from a vps backup?
I have an Ubuntu VPS backup from which I need to pull MySQL data. I was trying to install mysql on my Arch linux machine and copy the /var/lib/mysql files from the backup to my system. However, I ran ...
0 votes
1 answer
113 views
What DNS records are needed to ensure pop3 delivery from external mail senders succeeds?
My setup: Network: Low spec vps server, Mail server: postfix + dovecot + mysql, OS: ubuntu 16.04 (to be upgraded once mail config is complete). I have a single domain (call it mydomain1.com) ...
- 101