Questions tagged [mysql]

An open-source, relational database management system.

Filter by
Sorted by
Tagged with
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 ...
flix's user avatar
  • 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....
flix's user avatar
  • 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 ...
user10709800's user avatar
-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 | +---------------...
umarkaa's user avatar
-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://...
Brayan Tiwa's user avatar
2 votes
1 answer
95 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-...
agent provocateur's user avatar
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 ...
Chris's user avatar
  • 101
0 votes
1 answer
248 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 ...
gaetan's user avatar
  • 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? ...
Astora's user avatar
  • 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 ...
Watson's user avatar
  • 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 ...
Manuel Jordan's user avatar
0 votes
1 answer
214 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 ...
Manuel Jordan's user avatar
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....
Nickotine's user avatar
  • 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'...
telometto's user avatar
  • 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/...
bungee1980's user avatar
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/...
palmasd1's user avatar
  • 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 ...
AntonOfTheWoods's user avatar
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 ...
MD.Favaz's user avatar
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 ...
bungee1980's user avatar
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... ...
Teal_cfr's user avatar
1 vote
1 answer
580 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.
palmasd1's user avatar
  • 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 ...
Aldar's user avatar
  • 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 "$...
Jose Ace's user avatar
-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
ADESUNDAY 's user avatar
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 ...
RDK's user avatar
  • 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 ...
Aqo Cyrale's user avatar
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 ...
Azhinu's user avatar
  • 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 ...
IGGt's user avatar
  • 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 ...
TSG's user avatar
  • 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. ...
Amal P Ramesh's user avatar
-2 votes
1 answer
971 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 ...
Igor Savinkin's user avatar
0 votes
0 answers
178 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 ...
Igor Savinkin's user avatar
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 | ...
priyank's user avatar
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/...
jwa's user avatar
  • 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-...
user654019's user avatar
  • 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. ...
Sollosa's user avatar
  • 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 ...
Aseli Paul's user avatar
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 ...
telometto's user avatar
  • 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 ...
manmatha.roy's user avatar
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-...
Manuel Jordan's user avatar
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 ...
Sami's user avatar
  • 275
0 votes
0 answers
790 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, ...
H Moni's user avatar
  • 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....
DevaKI's user avatar
  • 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 ...
Kamil's user avatar
  • 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 ...
Javier Hernandez's user avatar
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. &...
genesis lubrigas's user avatar
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-...
wang's user avatar
  • 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/...
SeniorDeveloper's user avatar
1 vote
1 answer
543 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-...
eliot's user avatar
  • 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 ...
telometto's user avatar
  • 1,985

1
2 3 4 5
20