Questions tagged [mariadb]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers
7 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 ...
user avatar
  • 11
0 votes
1 answer
30 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, ...
user avatar
  • 1,042
0 votes
1 answer
35 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-...
user avatar
  • 1
0 votes
0 answers
24 views

How to restore mariadb to default after DB corruption

my DB got corrupted after that there was no free space available. I have tried many solutions, but nothing works so far. I have a backup of my application DB but not of the whole mysql DB. Despite ...
user avatar
1 vote
2 answers
460 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. ...
user avatar
0 votes
1 answer
76 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 ...
user avatar
0 votes
1 answer
40 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% ...
user avatar
  • 550
-1 votes
1 answer
114 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. ...
user avatar
1 vote
1 answer
148 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" ...
user avatar
  • 25
-1 votes
1 answer
74 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 (...
user avatar
  • 21
0 votes
0 answers
7 views

MariaDB: sanitizing data before INSERT, keeping raw data AND extract excerpt to another column

Objective: Receive syslog data from Kiwi Syslog, in same query insert both the raw message to column rawmsg AND excerpt source and destination info from raw message to columns source and destination. ...
user avatar
  • 467
1 vote
0 answers
36 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 ...
user avatar
  • 11
1 vote
1 answer
264 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 ...
user avatar
1 vote
1 answer
55 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 ...
user avatar
  • 2,517
0 votes
0 answers
81 views

DNF not listing some packages from local repository

I have a local repository of MariaDB 10.6 packages made with the following reposync syntax: reposync --download-metadata --newest-only --repoid=$REPOID --config=$REPOCONF -p $REPOPATH/ The contents ...
user avatar
-1 votes
1 answer
51 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-...
user avatar
0 votes
0 answers
15 views

SQL script to accept INFILE as parameter?

I have an SQL script, in which some data is being loaded from a file, something like this: LOAD DATA local INFILE 'test.csv' INTO TABLE test ... Now the path & name of this INFILE is hardcoded ...
user avatar
  • 1,591
0 votes
0 answers
17 views

High Availability Cluster with MariaDB

Can anyone explain in layman term regarding High Availability cluster with pacemaker? The current specification relies on MariaDB which is stored in Shared drive.
user avatar
0 votes
1 answer
117 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/...
user avatar
0 votes
1 answer
996 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 ...
user avatar
0 votes
1 answer
146 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, ...
user avatar
0 votes
1 answer
31 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`, `...
user avatar
0 votes
1 answer
141 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 ...
user avatar
0 votes
2 answers
2k 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 ...
user avatar
  • 467
1 vote
1 answer
96 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 ...
user avatar
  • 11
1 vote
1 answer
1k 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....
user avatar
  • 2,517
0 votes
1 answer
53 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: ...
user avatar
1 vote
0 answers
127 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 ...
user avatar
3 votes
1 answer
310 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 ...
user avatar
  • 173
0 votes
1 answer
31 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 ...
user avatar
0 votes
1 answer
8k 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 ...
user avatar
  • 25
1 vote
1 answer
2k views

Error while installing mariadb-server on Kali Linux

I'm starting to set up my first DVWA on my Kali Linux machine. I tried to install mariadb-server using apt-get install mariadb-server as a root. I ran into error and I couldn't proceed. Preparing to ...
user avatar
  • 59
0 votes
1 answer
77 views

CentOS OpenLdap Apache PHP and MediaWiki

So I have been trying to setup a "Free" wiki that integrates with my "Free" version of Active Directory (aka. OpenLdap), so I can get a super simple setup together for a dev group, ...
user avatar
0 votes
1 answer
138 views

How to delete files using grep?

Here the result of this command : sudo dpkg -l | grep mariadb It returns me this : ic mariadb-server-10.3 1:10.3.23+maria~bionic amd64 MariaDB ...
user avatar
  • 1
0 votes
1 answer
387 views

ERROR 2002 (HY000) while trying to connect to MariaDB

I'm on Linux Mint 19 and use MariaDB as database server for my wordpress site in localhost. I try to run MariaDB and when I check the status running systemctl status mysql.service I get this message: ...
user avatar
  • 1
0 votes
2 answers
1k views

Mariadb on Raspbian: Can't connect to local MySQL server through socket

I'm setting up a "clean" image for my home Raspberry pi running the latest Raspbian, and I'm finding a small problem when installing the mariadb database. So far, the steps I've taken are ...
user avatar
1 vote
0 answers
174 views

ARM version of MariaDB ODBC Connector

Is it possible to download a ARMv7 version of the MariaDB ODBC connector library (libmaodbc.so)? I started to build it from source but have got bogged down in compile issues. Its for a Raspberry Pi 3+ ...
user avatar
0 votes
1 answer
79 views

How to create an unprivileged sql database

I need to learn what sql is. But am too scared of creating a database as root. This is my current "progress": $pacman -Syu mariadb # succeeds $mysql_install_db --basedir=~/.sql/install --...
user avatar
  • 2,633
4 votes
2 answers
3k views

Failed to search for file: Failed to download gpg key for repo 'mariadb-main': Curl error (37)

I installed MariaDB on a computer with CentOS using the instructions given here: MariaDB Package Repository Setup and Usage - MariaDB Knowledge Base The basic command I used was: sudo yum install ...
user avatar
  • 169
1 vote
1 answer
267 views

Why is there a ROOT (as opposed to root) account for MySQL and MariaDB?

As far as I can tell, the MySQL and MariaDB database "ROOT" account is completely separate from the operating system's "root" account. Why did someone consider it a good idea to create the ambiguous ...
user avatar
0 votes
1 answer
161 views

Why does MySQL give me "ERROR 114 - Table Full"?

I have a MySQL database table with 31,107,600 rows in it. It's using InnoDB. This is on a CentOS 7 system. The table has these columns: id timestamp mac data direction site_id I want to create an ...
user avatar
  • 193
0 votes
2 answers
251 views

mariadb server wont start, modular dependency problems?

I'm trying to create a maridb table on a rhel instance in my ec2 container, but everytime I try to start mariadb I get this: Redirecting to /bin/systemctl start mariadb-server.service Failed to start ...
user avatar
  • 1
0 votes
1 answer
247 views

Ubuntu MySQL Failing install with Apt-Get

I previously had MariaDB installed and I'm wanting to install MySQL 5.7 on my server. I purged all files with mariadb and mysql. Though when I install MySQL-Server-5.7 I get the following error. (When ...
user avatar
1 vote
0 answers
86 views

Debian (Buster) Nextcloud Error While Trying To Create Admin User - Access Denied

I am performing a manual installation of Nextcloud on my personal machine running Debian (Buster). I've followed all of the steps of the instructions, up to the point where it wants me to complete ...
user avatar
  • 11
1 vote
0 answers
1k views

Unable to start mariadb

I'm not able to start mariadb getting following error while starting db service. root@server_name:~# systemctl status mariadb.service ● mariadb.service - MariaDB 10.3.9 database server Loaded: ...
user avatar
  • 41
0 votes
1 answer
311 views

Ubuntu 18.04 mariadb access error

I'm on ubuntu 18.04, i have installed maria-db, maria-db is running with the command: sudo service mysql status but when i write this command: sudo mysql -u root -p ERROR: i get this error: ...
user avatar
1 vote
0 answers
45 views

How I can detect whether the database layer is either mysql or mariadb using only netcat

Sometimes on docker entrypoint files I need to detect whether the database layer is either mysql or mariadb in order to provide the correct configuration for my application whilst I develop docker ...
user avatar
0 votes
0 answers
1k views

Accessing to Mariadb database with telnet from LAN

System is Debian 10 upgraded from Debian 9. MariaDB version is mariadb Ver 15.1 Distrib 10.1.41-MariaDB Server machine running telnet command responds like this telnet localhost 3306 Trying ::1... ...
user avatar
1 vote
2 answers
436 views

Installing MariaDB 10.4 on Centos 7

I am experiencing some trouble with installing MariaDB 10.4 on Centos 7. The official mariaDB guide says that a new repo file MariaDB.repo should created in /etc/yum.repos.d/ with the contents of: # ...
user avatar
  • 325
0 votes
2 answers
517 views

Python to IPTables safest way of altering

Does anybody know what the safest way is to alter IPTables from Python? For a schoolproject we're building a simple captive portal. When the user is authenticated (via python & mariadb) on the ...
user avatar