Questions tagged [mysql]
An open-source, relational database management system.
989
questions
1
vote
0
answers
29
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 ...
- 137
-2
votes
0
answers
33
views
MySQL install using cMake get permission denied even though the owner of dir is mysql
I have a CentOS 7.0 and I'm trying to install mysql mysql-5.6.21 through cmake using this script
cmake -DCMAKE_INSTALL_PREFIX=/data/local/tool/mysql-5.6.21 \
-DMYSQL_DATADIR=/data/local/tool/mysql-5.6....
- 137
1
vote
0
answers
34
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
51
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 |
+---------------...
- 1
-2
votes
3
answers
88
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://...
2
votes
1
answer
94
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
48
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
247
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
69
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?
...
- 439
0
votes
1
answer
64
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
214
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,738
0
votes
1
answer
213
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,738
1
vote
1
answer
51
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....
- 467
0
votes
0
answers
47
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'...
- 1,985
0
votes
2
answers
103
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/...
- 15
0
votes
1
answer
94
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/...
- 115
2
votes
0
answers
37
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
126
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
46
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 ...
- 15
0
votes
0
answers
40
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
577
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.
- 115
0
votes
2
answers
204
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 ...
- 43
0
votes
2
answers
430
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
209
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
44
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
108
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
191
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
344
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,457
0
votes
0
answers
23
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,698
0
votes
1
answer
94
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
969
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
177
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
114
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
142
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
457
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,307
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,929
0
votes
1
answer
67
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
506
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 ...
- 1,985
0
votes
0
answers
32
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
92
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,738
0
votes
1
answer
960
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
789
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
1
vote
0
answers
77
views
Prometheus exporter for MySQL can can run SQL query delete update insert?
Hi anyone can answer about this questions ?
I have ubuntu cloud server, One of my office colleague has installed mysqld exporter in the cloud. The mysqld exporter always connected with my cloud server....
- 21
2
votes
0
answers
145
views
Separate binary logs for each database in MySQL
I have been working with Sybase databases for few years. In Sybase databases you have separate binary log for each database. Backup and restore operation with binary logs for single database is not ...
- 749
1
vote
2
answers
43
views
Advice for best way to use old 32 bit machines
Most PCs at work are 64 bit by now, although we still old 32 bit ones.
We are not in a position to just throw them away, but of course we don't want to drag down the entire workplace just to keep ...
0
votes
1
answer
596
views
how execute curl in mariadb/mysql stored procedure
I am using information from here and here.
I am running mariadb server on Debian 10. I download and copied the files to the server and execute the install.sh and I get the following error below.
&...
1
vote
0
answers
83
views
The following issues occur while installing mysql [closed]
The following issues occur while installing mysql
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
dpkg: error processing package mysql-community-...
- 11
3
votes
1
answer
2k
views
Postfix Error while loading shared libraries: libmysqlclient.so.18
When I try to start postfix I get these errors:
/usr/sbin/postconf: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such...r directory
/usr/bin/...
- 131
1
vote
1
answer
542
views
How to install a package in Solaris 11 from file?
How to install a package in Solaris 11 from file (not from the package repository)?
I am trying to install a .pkg file on a Solaris 11 SPARC machine, however, I get errors:
# pkg install mysql-...
- 31
0
votes
1
answer
248
views
How can I reinstall mysql/mysqld on Fedora?
I'm experiencing some issues where the mysqld won't start, so I'd like to purge or (at least) reinstall its files in order to replace the current configuration files with the stock ones so that it ...
- 1,985