Skip to main content

Questions tagged [mariadb]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
49 views

AlmaLinux 9.4 how to update MariaDB to a later version

I have a brand new AlmaLinux 9.4 installation with my hosting company and it appears to have been pre-installed with a LAMP stack. The MariaDB server version currently running is MariaDB 10.5.22 but I ...
MrCarrot's user avatar
  • 101
0 votes
0 answers
152 views

How to identify which process is causing a high memory consumption?

I am running a virtualized Arch Linux machine. From time to time, it shows a high memory consumption and I do not know the reason because basically, the machine is sitting idle. # ps aux --sort=-%mem ...
Stacker12345's user avatar
0 votes
0 answers
45 views

MariaDB 10.9.* for Fedora 39 - CPack Error

I have updated my linux-server to Fedora 39 and my MariaDB doesn't work now, because old files have been generated for MariaDB 10.9, but after update it auto-install MariaDB 10.5. What I can do in ...
Timofey Stanskov's user avatar
0 votes
0 answers
16 views

Slow Queries, memory utilization seems low, "Database Error" messages when under only moderate load

I have a site that is set up just like the other 20 except this one is not handling database traffic like the others. It has 24 processors, 196 gig of ram. Yet under large load I see know more used ...
user2255739's user avatar
0 votes
1 answer
253 views

start mariadb but systemctl status mariadb with failed

I installed mariaDB under the path ‘/app/mysql’; Since the configuration file could not be found, I created the 'my.cnf' file under the 'etc/mysql' path and copied the content online, my.cnf CODE: [...
GOODDJ's user avatar
  • 1
0 votes
0 answers
43 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
0 votes
2 answers
261 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
  • 53
0 votes
0 answers
106 views

Slow query log: where should be configured on mariadb o a debian 12?

If I do show global variables like "%slow%" I get these results But I am not able to find where these values are set up. I tried to find, litterally cd /etc/mysql grep slow -R -n And ...
realtebo's user avatar
  • 957
1 vote
0 answers
34 views

"Access Denied user root error code 1045 (28000)" after changing root passwords

I'm encountering an "Access Denied user root error code 1045 (28000)" error with user root. I'm facing this problem after changing passwords. It was working fine before, and I'm confused ...
Mushtaq Ahmad's user avatar
0 votes
1 answer
35 views

Why can I not transfer a db from one container to another?

In my case, I have 2 mariadb containers running with 2 seperate volumes: CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS ...
Dimitrios Desyllas's user avatar
0 votes
0 answers
41 views

nextcloud app loses access to directory after another directory is mounted into it

There is a cloud based on the nextcloud application, it works on the server where apache is installed, there is also a server where the mariadb database is spinning and a server where glusterfs is ...
Maverick's user avatar
0 votes
1 answer
43 views

I can't find where to put these options, hence no sock file

I have installed mariadb-server and after a lot of struggling, I managed to get it to re/start without errors. However, there's no sock file so I can't even log in. It also doesn't show in netstat -...
Tolga Ozses's user avatar
0 votes
0 answers
193 views

How to use tmpfs in MariaDB when SELinux is enforced?

Running AlmaLinux 9.2 and MariaDB 10.11. Trying to use in my.cnf: tmpdir = /dev/shm This works fine when PHP-FPM is connecting using TCP port. Now trying to use faster Socket (/var/lib/mysql/mysql....
ivp's user avatar
  • 1
1 vote
1 answer
1k views

Why am I getting this error on mariadb installation?

I am trying to follow this article and systemctl start mariadb.service gives me Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb....
Tolga Ozses's user avatar
0 votes
1 answer
117 views

Website down - MariaDB failed

I had a working website for 2 years, which suddenly stopped working. I haven't performed any updates or upgrades. When I woke up, I noticed that it was not functioning. I contacted my hosting provider,...
magi_gr's user avatar
0 votes
1 answer
431 views

Cannot upgrade MariaDB Connector/C on Parrot OS

Please note very new to ParrotOS + Python. Error output when trying pip3 install mariadb : MariaDB Connector/Python requires MariaDB Connector/C >= 3.3.1, found version 3.1.18 I cannot seem to ...
alois netgen's user avatar
0 votes
0 answers
917 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
0 votes
1 answer
65 views

How can I get MariaDB to resume action?

I was working on my Wordpress site, and to get a non-database, HTML version suitable for my datamine, such as is running correctly at https://orthodoxchurchfathers.com and https://searchgkchesterton....
Christos Hayward's user avatar
0 votes
1 answer
328 views

Setting custom MariaDB max_allowed_packet value in Debian 11?

Our Moodle server, running Debian 11 (bullseye), now seems to produce an "Error writing to database" message in the web browser when course admins try to manually backup some (larger) ...
dave559's user avatar
  • 389
0 votes
1 answer
654 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
1k views

pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([Errno 99] Cannot assign requested address)")

I have a streamlit app that requires connection to MariaDB. When I run docker-compose up I get this error: pymysql.err.OperationalError: (2003, "Can't connect to MySQL server on 'localhost' ([...
divyashie's user avatar
0 votes
1 answer
1k views

Selinux php-fpm httpd and mariadb socket connection

New note with important details I just ran a few version tests and resulted in the following: Alright, here’s my latest update: 10.5 works 10.6 doesn’t 10.7 works 10.8 work etc. I was hoping to use ...
Brian's user avatar
  • 292
1 vote
0 answers
532 views

Missing dependencies after migration to Debian 11

After update to Debian 11, I got this error message apt-get upgrade Reading package lists... Done Building dependency tree Reading state information... Done You might want to run 'apt-get -...
Neiak's user avatar
  • 39
2 votes
1 answer
2k views

How to do offline-installation of multiple images via podman load/save

I am using an app depending on the image docker.io/library/mariadb:10.7. Images can be pulled, and saved in a tarball: podman pull \ docker.io/photoprism/photoprism:latest \ docker.io/library/...
pod's user avatar
  • 31
1 vote
0 answers
90 views

raspberrypi - recover innodb data from 32 bit mariadb server to 64 bit server

After a system crash of my raspberrypi 3B+ (32 bit, OS buster) I could not recover madiadb (version: 10.3.31) data on localhost for several virtual hosts. I had to buy a new raspberrypi 4 with 64 bit ...
Walter's user avatar
  • 11
0 votes
1 answer
2k views

Can't get ODBC working with MariaDB

Linux Mint 20 (Ubuntu 20). MariaDB version: "mariadb Ver 15.1 Distrib 10.7.3-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2" I want to run LibreOffice Base as the front end, ...
mike rodent's user avatar
  • 1,142
0 votes
1 answer
109 views

why when I execute a select it works and when I execute an update the script blocks?

when I try to execute a query of type update the script hangs and the sql console stays still. This command executes all queries in the script: res=$(mysql --defaults-file=conf_file --skip-column-...
JJWRX's user avatar
  • 1
2 votes
2 answers
3k views

MariaDB & Amazon Linux 2: ERROR: ld.so: object '/usr/lib64/libjemalloc.so.1' from LD_PRELOAD cannot be preloaded

Following AWS documents, I'm attempting to get a basic LAMP server up and running. Everything appears to be working fine. Logging into MySQL either through the terminal or phpMyAdmin (GUI) works. ...
A Simple Bovine's user avatar
0 votes
1 answer
290 views

Can't restart MariaDB after adding datadir line to my.cnf file

Having a issue getting MariaDB to restart after adding the following line to the [mysqld] section of my.cnf: datadir = /home/mysql It won't restart. Could this be a permissions issue. This is the ...
Samuel Brown's user avatar
0 votes
1 answer
104 views

Free up mysql space on low-disk PC

I have a PC with a small disk: Filesystem Size Used Avail Use% Mounted on /dev/root 3.5G 3.1G 249M 93% / devtmpfs 459M 0 459M 0% /dev tmpfs 463M 0 463M 0% ...
Fco Javier Balón's user avatar
-1 votes
1 answer
482 views

Can't get MariaDB to start..OpenSuse 15.2

I am logged in as root and below is what I see when I try to start the service. I have removed and reinstalled, I have also ran mysql_install_db. So far I haven't been able to resolve this issue. ...
Samuel Brown's user avatar
1 vote
1 answer
664 views

Why can't install specified mariadb version with readline library?

My os info: uname -a Linux debian 5.10.0-9-amd64 #1 SMP Debian 5.10.70-1 (2021-09-30) x86_64 GNU/Linux Locale setting: locale LANG=en_US.UTF-8 LANGUAGE=en_US:en LC_CTYPE="en_US.UTF-8" ...
showkey's user avatar
  • 395
-1 votes
1 answer
154 views

mysql on artix linux gives the 'ERROR 2002 (HY000)'

I'm using artix linux with runit init system and I've stumbled upon this issue where I can't login into mariadb by using sudo mysql -u root -p because it gives me the following error: ERROR 2002 (...
Coelll's user avatar
  • 41
1 vote
0 answers
129 views

Dovecot - password query syntax error

Whenever Thunderbird attempts to connect to my server I receive an error in the maillog of dovecot: auth-worker(32527): Error: sql(admin,xxx.xxx.xxx.xxx,): Password query failed: You have an error in ...
Atzin's user avatar
  • 11
1 vote
1 answer
1k views

start mysql/mariaDB service after datadir change

I installed the mariadb server and create a root user with a password with sudo apt install mariadb-server sudo mysql_secure_installation Since I use a Rasperri Pi I want to swap the DB to an ...
Anton Hinkel's user avatar
1 vote
1 answer
787 views

How to query mysql from cron script?

I have the following code in my script: mapfile results < <(mysql --batch -u $DB_USERNAME -p$DB_PASSWORD $DB_DATABASE < query.sql) and it works fine if running from command line. But if ...
Dims's user avatar
  • 3,285
-1 votes
1 answer
327 views

mariadb server not running after install amazon linux 2

My mariadb server is not running after I install it with yum install mariadb-server. after running this command, it displays: mariadb-server-10.2.38-1.amzn2.0.1.x86_64 is obsoleted by mysql-community-...
eggplants's user avatar
0 votes
1 answer
840 views

unable to use mysql in mariadb server with no clear reason

in case i just type mysql -u root -p and enter my password i enter to my database but now i still get one message every time i say mysql and any option like this output root@Dodge:~# mysql Usage: /etc/...
Mahmoud Adel Mansour's user avatar
0 votes
1 answer
2k views

Debian 10 - Broken MariaDB update - system upgrade problems

My system has a broken MariaDb update going from 10.3 to 10.4. MariaDb does still work fine, but now I am having system upgrade issues. I have tried looking online for solutions but can't seem to find ...
pmichaels's user avatar
0 votes
1 answer
355 views

mariadb fails to start on raw drive filesystem

I have a Debian 10 machine having it's large virtual drive formatted without a partition. It comes up as /dev/sdb in a df. The instance of mariadb had been in /var/lib/mysql as standard for Debian 10, ...
TreedEagle's user avatar
0 votes
1 answer
49 views

encryption password by script failed

I am testing to add a user to my database with a bash script! my code for my bash script is : mysql -u root <<MYSQL_SCRIPT USE mail_server; INSERT INTO mail_server.virtual_users (`id`, `...
Rayen Ben Said's user avatar
0 votes
1 answer
416 views

Can't start MariaDB after moving datadir to external drive

I am running a MySQL server using MariaDB on my Raspberry Pi. I am expecting the db to grow, so I want to move my db to an ext4-formatted external drive. So far I have been following this online ...
Pierre Cathé's user avatar
-1 votes
2 answers
10k views

How to install MariaDB-Client on CentOS 8? It says 'unable to find a match'

Objective: Installing client only of MariaDB for command line testing of working connection webserver <> external server. There are numerous tutorials to be found which describe MariaDB ...
DavDav's user avatar
  • 519
2 votes
1 answer
865 views

How do I install MariaDB to non-default root and data directories in Debian?

I'd like to install mariadb on Debian 10 with the --basedir=/usr/local/mariadb and --datadir=/data/mariadb. I've tried to add these options to the apt install mariadb-server command line but I get ...
Bill's user avatar
  • 21
2 votes
1 answer
2k views

Unable to reset MariaDB root password

I am doing: $ sudo vim /etc/mysql/mariadb.conf.d/50-server.cnf then adding skip-grant-tables then $ sudo service mysqld restart then $ mysql -u root -p Enter password: Welcome to the MariaDB monitor....
Dims's user avatar
  • 3,285
0 votes
1 answer
228 views

my startup script does not start when I want to

So I am having a bash script in /etc/init.d/ containing this init info: ### BEGIN INIT INFO # Provides: minio server # Required-Start: $local_fs $remote_fs $mysql $all # Required-Stop: ...
Monocito's user avatar
1 vote
0 answers
218 views

MariaDB connector (remote)

I'm new to databases and have some very basic how-to/where-to questions: I have successfully setup a MariaDB + phpmyadmin on my raspberrypi zero (running the latest diet-pi), including a database ...
user2305193's user avatar
3 votes
1 answer
509 views

logrotate reports "my_print_defaults: unknown option '--mariadbd'"

My server is running Ubuntu 18.04.5 and I recently installed mariadb 10.5.5 from the MariaDB repositories (not from the Ubuntu repositories where that version is not available yet). Since then, I ...
ygramoel's user avatar
  • 243
0 votes
1 answer
70 views

After reducing Mutt storage size, how do I get that storage reflected back into df

My goal is to get back the storage space in my opt directory. I want to be able to see it growing in size so that regular maintenance checks mean I can down size it when space is needed. Before I ...
TheArchitecta's user avatar
0 votes
2 answers
14k views

Why I get "Access denied for user \'root\'@\'localhost\' (using password: NO)" after I added .env variables?

I'm using mariadb with nodejs on centos 8. Whenever I add process.env variables to my mysql.createConnection function I get error Access denied for user \'root\'@\'localhost\' (using password: NO) but ...
CHEWKOK's user avatar
  • 25