Questions tagged [mysql]
An open-source, relational database management system.
997
questions
-1
votes
1
answer
52
views
Can ClamAV detect malicious files on a MySQL/MariaDB server?
Can ClamAV help detect malicious files (ie malware, rootkits, etc) for a MySQL/MariaDB server, specifically the /var/lib/mysql data folder?
The database server is a single role and locked down both by ...
2
votes
4
answers
591
views
How can I append comma except lastline?
With following shell script,
I read file
and for each line
generates SQL fragments
#!/bin/bash
CURRDATE=$(date +'%Y-%m-%d %H:%M:%S')
echo $CURRDATE
echo $OUTPUT
echo "SET SESSION AUTOCOMMIT = ...
- 544
0
votes
0
answers
34
views
Unable to locate package percona-xtradb-cluster
I am unable to install the percona xtradb on Amazon aws free tier ubuntu 24.04 LTS, while trying to install same as instructions that are given in this document https://docs.percona.com/percona-xtradb-...
- 101
0
votes
0
answers
10
views
Capturing Data from Sensors Sequentially Using Raspberry Pi 5 and NRF24
I am developing a project on Raspberry Pi 5. For this project, I have 6 sensors and I collect data from these sensors. I use NRF24 when collecting data. I store the data I collect in the database I ...
- 1
0
votes
2
answers
98
views
MySQL binlogs on cifs share getting OS errno 13 - Permission denied
I am creating a Rocky Linux 9 server to replace a CentOS 7 server. The original CentOS 7 server mounts a Windows shared directory where it stores the binlogs. When I try to duplicate this for the ...
- 3
1
vote
0
answers
21
views
Mysql container image behaving diferently between docker and podman in github actions
I have a github workflow that spins up a MySQL container. I'm using podman right now, because that matches our development workflow, but I'm seeing some weird differences in behavior between "...
- 36.6k
0
votes
0
answers
42
views
MySQL Server keeps hitting 100% CPU
My server has 800+ days uptime, but ever since a couple weeks the MySQL server keeps hitting 100% CPU and I have to restart the mysqld service.
Where do I start to find out where this issue is coming ...
- 571
0
votes
1
answer
1k
views
"Error in network definition: expected mapping (check indentation)" Syntax error in Netplan, I am trying to set up a static IP for my LAMP stack
Below are the configs for the yaml: file /etc/netplan/{filename}.yaml
network:
version: 2
renderer: networkd
ethernets:
eno1:
dhcp4: false
dhcp6: false
addresses:
[10.0....
0
votes
1
answer
111
views
Fedora 39 - Installing mysql workbench
I'm having some troubles installing mysql workbench on Fedora 39. I'm following https://idroot.us/install-mysql-workbench-fedora-37.
> sudo dnf install https://dev.mysql.com/get/mysql80-community-...
- 141
1
vote
0
answers
39
views
Is there an alternative way to Install MySQL that uses a custom config other than using make?
I just downloaded a complete game source code and intend to build a webserver on my CentOS 7. However, there are so many libraries needed, and one of the required steps is to install MySQL in a custom ...
- 143
1
vote
0
answers
43
views
mysqld thread count exceeds max_connections
As the question title suggests: I have set max_connections = 2 in my my.cnf file, but when I activate my mysql daemon, the thread count sits at 37. I am searching online but cannot find indication my ...
- 33
-2
votes
2
answers
87
views
mysql downgrade version kali linux
10.11.6-MariaDB-2 I have this version of mysql
MariaDB [(none)]> SELECT VERSION()
-> ;
+-------------------+
| VERSION() |
+-------------------+
| 10.11.6-MariaDB-2 |
+---------------...
- 11
-1
votes
3
answers
936
views
Unable to install MySql on Amazon Linux 2023
I am working on a EC2(AWS) machine running Amazon Linux 2023.4.20240319. I need to install apache, php, and mysql. I stuck with mysql. I have followed many instructions found on the internet:
https://...
- 11
2
votes
1
answer
596
views
Installing mysql-community-devel on RHEL9, "Errors during downloading metadata for repository 'mysql80-community'"
This is my second instance where I am doing this installation and it is not working as expected...
dnf -y localinstall mysql80-community-release-el9-5.noarch.rpm
I installed mysql80-community-release-...
0
votes
1
answer
119
views
Can I use symbolic links for a MySQL database
I have a MySQL installation on my machine where I need to add a very large table that will max out existing capacity.
I've previously housed MySQL data on external drives but I'd prefer to keep as ...
- 101
0
votes
1
answer
2k
views
Install mysql 8.0 on Debian 12
I'm starting with a new installation.
sudo wget https://dev.mysql.com/get/mysql-apt-config_0.8.29-1_all.deb
sudo apt install ./mysql-apt-config_*_all.deb
sudo apt update
sudo apt install mysql-server
...
- 1
0
votes
1
answer
192
views
How to hide a variable value when set -x is on
I need to use set -x in my script to show the executed commands in my log
but there is a variable which is a password, so this password is showed in plan text
Is there a way to hide only a variable?
...
- 449
0
votes
1
answer
69
views
Debian/Ubuntu Random Disk Expansion
Running mysql 8.0.34 on debian 12 (BookWorm).
I get this random issue where the disk looks like it is being steadily consumed, but when I step into the disk or search the disk there doesn't seem to be ...
- 103
0
votes
0
answers
243
views
Fedora 39 - How to remove expired GPG key installed by MySQL?
I have the following situation
Is not possible install MySQL 8 on Fedora Workstation 39
Pls, see how was installed to understand this post. Anyway I am going in peace to wait until mysql itself ...
- 1,832
0
votes
1
answer
337
views
Is not possible install MySQL 8 on Fedora Workstation 39
Through VirtualBox was installed Fedora Workstation 39. Now I tried to install MySQL 8 server . I got the mysql80-community-release-fc39-1.noarch.rpm file from https://dev.mysql.com/downloads/ about ...
- 1,832
1
vote
1
answer
146
views
mysqld Settings in my.cnf not Being Applied When Executing mysql
mysql is ignoring the settings under [mysqld] in my.cnf, it picks up the settings for [client] and [mysql].
How do I fix this?
I tried brew services mysql restart, but it didn't make a difference.
my....
- 489
0
votes
0
answers
96
views
Where are files that are created with rootles systemd/quadlet stored?
I was playing around and following this guide to see if I could spin up a container at startup. I am now done with it and have removed the systemd service from $HOME/.config/containers/systemd/ but I'...
- 2,085
0
votes
2
answers
124
views
I lose permission every day at midnight
I require a file at the top of my PHP scripts. The file just has connection object for MySQL:
$c->new mysqli('host','usr','pass','db')
The file has 400 permission: -r--------
and I keep it in /etc/...
- 27
0
votes
1
answer
192
views
MySQL doesn't work with libmysqlclient
Mysql is on
libmysqlclient: /lib/x86_64-linux-gnu/libmysqlclient.so.21
dlopen error: /lib/x86_64-linux-gnu/libmysqlclient.so.21: invalid ELF header
ERROR loading mysql = /lib/x86_64-linux-gnu/...
- 127
2
votes
0
answers
40
views
PROMPT_COMMAND for other historied commands (mysql, psql, etc.)
I have
export PROMPT_COMMAND='history -a; history -c; history -r'
in my .bashrc and would be lost without it. I usually have 3+ windows and 20+ tmux panes at all times, and this means that I get ...
- 123
0
votes
0
answers
200
views
How to Fix "MySQL error message was : DBI connect failed : Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ?"
I upgraded my VPS with the provider Contabo, and since then, I have been experiencing issues. Unfortunately, they have not been responsive or provided any support.
when i do command : service mysql ...
- 1
0
votes
0
answers
78
views
dialog checklist from mysql
I have a todo list in mysql. I want to make it more interactive using dialog.
#!/bin/bash
mapfile -t todo < <(mysql -uroot -hmy_host -p$my_pass -Dmy_db -BNe "select task from todo where ...
- 27
0
votes
0
answers
50
views
Mysql server under pressure?
I'm having issue with a server than hosting 5 Wordpress and 1 staging
Including on Woocommerce and one Bbpress with huge db.
The server got 120Go Ram with 500Mo swap set.
I have a TTFB around 3s...
...
- 1
1
vote
1
answer
1k
views
How to install libmysqlclient-dev at AlmaLinux 9.2
I need to install libmysqlclient-dev but get No match for argument: libmysqlclient-dev Error: Unable to find a match: libmysqlclient-dev.
- 127
0
votes
2
answers
297
views
Why do we misnomer MariaDB as a "mysql-server"?
I've had an interesting discussion recently, about whether it is okay to call MariaDB a "mysql server" when in reality, Maria is not 100% compatible with MySQL.
I understand it was ...
- 53
0
votes
2
answers
684
views
For loop sql query each row from variable output in shellscripts
The $columns_output inside value like below:
dbname1.tablename
dbname2.tablename
dbname3.tablename
dbname4.tablename
Part of the scripts section
$columns_output=""
for value in "$...
- 5
-4
votes
1
answer
288
views
MySQL on Linux, running on Windows 10, gives error "Failed to connect to bus"
I’m trying to run MySQL on Linux which is running on Windows 10 but I’m getting an error:
Failed to connect to bus: host is down on linux
0
votes
1
answer
53
views
Which OS, SQL, Postfix and Dovecot files/folder need to be backup for disaster recovery?
I'm running an e-mail server (Postfix/Dovecot) on a Pi4, Buster OS. We want to setup a parallel Pi (same basic image) and use rsync to transfer critical files to this Pi using a cron job on a regular ...
- 23
0
votes
1
answer
123
views
Ubuntu 23.04 MySQL set root password from non-interactive .sh script in docker
I have a docker ubuntu image used for automated testing that needs several things installed, one of those being a mysql server. I install it using apt.
I can't use the server because I don't have the ...
0
votes
1
answer
278
views
MySQL ignore LD_PRELOAD
I trying to use jemalloc with MySQL. I found that I should add enviroment variable LD_PRELOAD to SystemD unit and thats all.
But lsof /usr/lib/x86_64-linux-gnu/libjemalloc.so.2 shows nothing. I also ...
- 1
0
votes
0
answers
410
views
Debian has wrong source.list file after update
I have just carried out an upgrade from debian 11 to debian 12, and that appears to be fine. I now need to update the mysql instance to 8.0.34.
I have downloaded the latest mysql-apt-config and ...
- 2,507
0
votes
0
answers
24
views
Solution to phpMyAdmin login problem seems unsafe
I had trouble logging into my myPhpAdmin web interface, so after finding numerous posts suggesting I added my un/pw to the config file like this:
$cfg['Servers'][$i]['user'] = 'root'; //mysql username ...
- 1,768
0
votes
1
answer
106
views
SFTP user login details real-time filtering
I have enabled the SFTP login log into the default logfile /var/log/syslog and tried to filter the login time of each user and insert into the database.
But the filtering is not worked as I expected.
...
- 419
-2
votes
1
answer
1k
views
Can't start mysql server at AlmaLinux
I try to start mysql server at AlmaLinux:
[asigor@89 etc]$ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
it seems to me I can't start ...
- 147
0
votes
0
answers
228
views
Failure to install MySQL server at AlmaLinux
I try to install MySQL server at Almalinux v. 8.7
$ sudo dnf install mysql
PostgreSQL 9.6 for RHEL/CentOS 8 - x86_64 757 B/s | 146 B 00:00
Errors during downloading metadata for ...
- 147
0
votes
0
answers
144
views
How to kill multiple process list using command in linux for DB2
I connected mysql in linux server using mysql -u root -p dbnmae then i use cmd show processlist; and its showing result like
+---------+------+
| Id | User |
+---------+------+
| 123 | root |
...
- 1
0
votes
2
answers
163
views
mysqldump failing when launched from script
Running next command in terminal is working fine like expected.
/var/www$ sudo mysqldump --defaults-extra-file=/mnt/./.sql/mysqldump.cnf --databases site3 --hex-blob | sudo tee /mnt/site3/...
- 13
-1
votes
1
answer
499
views
error in installing mysql and connecting to it in wsl2 (Ubunto 22.04)
I am trying to install MySQL on Ubuntu 22.04 (WSL2) and these are the steps that I did:
1- Installing mysql server:
root@mans-pc:~# sudo apt-get update
Get:1 http://security.ubuntu.com/ubuntu jammy-...
- 2,337
2
votes
1
answer
39
views
ansible mysqldb not accepting item in tagrget options
I have a db host, on which some sql files are present. I want to source it into db using an ansible playbook. so I find all files & register in variable, then try to source those using below code.
...
- 1,971
0
votes
1
answer
86
views
could not find driver QueryException
Had this problem where my website couldn't load, and it was throwing an error:
could not find driver QueryException
Most answers hinted at uncommenting the ;extension=pdo_mysql.so line in the php.ini ...
0
votes
1
answer
583
views
Why won't my MySQL Podman container run?
I have installed "Development Tools" and run the following commands:
podman pull mysql:latest # this is pulled from docker.io
podman images # lists ...
- 2,085
0
votes
0
answers
33
views
wordpress can not find database, while mysql_client can
I am trying to prepare a WordPress site, on my public web server, running apache2. The database host, I am trying to use, for the WordPress installation, is another server.
While I can successfully ...
- 197
0
votes
2
answers
99
views
Is not possible change MySQL's port at Fedora Server 36
For Fedora Server 36 was installed MySQL 8 Community through the .rpm from MySQL Community Downloads. Now according with the Editing Conf. Files section is indicated to use the /etc/my.cnf.d/community-...
- 1,832
0
votes
1
answer
1k
views
Server is slow even though there are enough resources
I'm running about 450 simple webistes using Wordpress Multisite on a VPS with Debian 10.
Here are some data about the resources:
root@hr711523385:~# free -mh
total used ...
- 275
0
votes
0
answers
983
views
mariadb service not found in centos 8
On a Centos 8 server I'm trying to install MariaDB and MySQL.
I have used this command
dnf install mariadb-server mariadb -y
mysql-community-server-5.7.40-1.el7.x86_64 was installed after that.
Now, ...
- 1