Questions tagged [mariadb]

MariaDB is a community-developed branch of the MySQL relational database management system.

Filter by
Sorted by
Tagged with
0
votes
0answers
16 views

problems in installing mariaDB in wsl2

I am trying to install MariaDB in WSL2, but it's showing me the following errors - sachinpandeyatd@DESKTOP-Q3O2EQE:/mnt/c/Users/Hp/documents/server$ sudo apt-get install mariadb-server Reading package ...
0
votes
0answers
32 views

how to install MariaDB 10.3.28

I am trying to install shopware on Ubuntu server 20.04 but idk how to install the specific version off MariaDB and shopware dosen´t support 10.3.29 see https://docs.shopware.com/en/shopware-6-en/first-...
0
votes
0answers
47 views

CyberPanel stopped working as MariaDB uninstalled, when reinstalling still isn’t working…

So I have CyberPanel installed after 2 days MariaDB came uninstalled after reinstalling it using: sudo apt install -y mariadb-server I can do sudo MySQL which works fine, but even after restarting ...
0
votes
2answers
2k views

Ubuntu 20.04 weird problems on mariadb-server-10.3 upgrade

I have just performed a dist-upgrade on ubuntu 20.04 server and got stuck on mariadb-server-10.3 The apt process hung on this package and after 20 minutes waiting I have killed the process. After that,...
0
votes
0answers
44 views

How to tell MariaDB on Ubuntu to use OpenSSL instead of YaSSL

So, for some reason, my MariaDB uses YaSSL 2.4.4 When I try to open a Sequelize connection to my database it does not work. I know that it does work, when OpenSSL is used. However I can't find any ...
0
votes
0answers
30 views

Issues with MariaDB 10.3 development libraries and Ubuntu 20.04

Trying to install any of the MariaDB 10.3 development library packages for the version that comes with Ubuntu 20.04 seems to result in circular or unmet dependencies. I ran into this when trying to ...
0
votes
1answer
53 views

Ubuntu 20.04 ownCloud error

I'm having some issues with a fresh installation of ownCloud on my Ubuntu 20.04 desktop. This is what i get after trying to login:
0
votes
0answers
46 views

docker: mariadb replication on different host

I need to replicate my mariadb container to another host docker engine's mariadb container. All the examples I found are replicating two mariadb inside a same host. Any suggestions are greatly ...
0
votes
1answer
44 views

How can I Set wait_timeout for a Spesific Database on MySQL?

I am setting a global wait_timeout value on my.cnf file but I want to set different wait_timeout values to different databases and it must not be in software side, I need to make it on MySQL service ...
0
votes
0answers
28 views

Why Mariadb Stops Logging During Connection Problems?

I have faced some connection problems while connecting to a MariaDB server. The connections that I opened where closed anormally. When I checked the log files at /var/log/mysql/mariadb-bin.000xxx I ...
0
votes
0answers
20 views

Installing Wordpress on Apache2, just showing configuration

I’m trying to install Wordpress on Apache2, but all I’m getting when I’m trying to go finish the installation in Wordpress it only shows one of the MySQL-config files. I’ve tried to google it, but I ...
0
votes
1answer
691 views

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/run/mysqld/mysqld.sock' (2)

I just installed mariadb on my parrot sec and I tried sudo mysql_secure_installation here is the output : NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB SERVERS IN ...
0
votes
0answers
25 views

What is the Best Way to Start Closed Galera Clusters?

I have a 3-Cluster Galera replication and last day electricity has gone off. When I started the Mariadb servers, I saw that cluster could not start, three of them failed. I edited the grastate.dat and ...
0
votes
1answer
93 views

phpmyadmin cannot log into MariaDB

I have just installed apache2, php7, and mariadb on a new ubuntu 20 install. I had a problem getting phpmyadmin to come up but fixed it with an older answer from ask ubuntu. But now I cannot log into ...
0
votes
0answers
21 views

Why I Can't See MySQL Logs in a Time Range?

I am using Mariadb Galera 3-Cluster replication and yesterday I faced a lot of db exceptions on applications. So the applications wanted to insert data to db but some of data could not be inserted. ...
1
vote
1answer
617 views

Migrating Ubuntu 20.04 LAMP from MySQL to MariaDB

Status I currently run a LAMP server on Ubuntu 20.04, that has a MySQL server containing several Drupal and Wordpress databases, along with a PHPMYADMIN db. Request Is there some super smart MySQL ...
0
votes
1answer
52 views

How Can I Make Configurations for MySQL to Log Only Important Things Like “Error”

A MariaDB-Mysql server is logging everything and somethimes logs reach 100gb+ and they grows until the logrotate rotates them. I want that the MySQL must only logs necessary things like Error, not ...
1
vote
1answer
701 views

Ubuntu 20.04 - MySQL JDBC driver

Is there a way to install MySQL JDBC driver from Ubuntu 20.04 repository? It looks from other questions (askubuntu, stackoverflow) that it was contained in libmysql-java (which is no longer there), ...
0
votes
1answer
79 views

Why My Logrotate Configurations Doesn't Work Correctly for MySQL-MariaDB?

I am using an MariaDB Galera 3-Cluster and I saw that the mysql logs on Node 2 grows up to 100gb and I decided to limited these logs that will not grow a lot. I used logrotate for that, so an file ...
0
votes
1answer
745 views

MariaDB 10.3 does not start after Ubuntu 20.04 reboots after changing the data directory to a different drive

I'm having an unusual problem. I tried to change the data directory for my MariaDB installation and it does not work after rebooting the computer: I copied the entries from /var/lib/mysql/ to /mnt/...
0
votes
1answer
43 views

ppa for ubuntu-packaged mariadb-10.4 for ubuntu 16.04 xenial

Is there a ppa or other repo providing ubuntu-style packages of mariadb 10.4 for ubuntu 16.04? I'm trying to easily get some vms upgraded from mariadb-10.0 (server and client).
1
vote
1answer
360 views

Mysql not working, After uninstall Mariadb in Ubuntu

I have PHP and Mysql was already running on Ubuntu VERSION 20.04 Today, I have tried to install the Maria db, but it wasn't working, So i have removed the mariadb using below command apt-get purge ...
3
votes
1answer
1k views

Unable to install MariaDB on Ubuntu 20.04

I have been trying to install MariaDB on my system, but the installation always stops at the following step $ sudo apt install mariadb-server Reading package lists... Done Building dependency tree ...
0
votes
0answers
77 views

Minecraft Server won't connect to a MariaDB or MySQL database

I just switched to ubuntu and I'm trying to link my MariaDB database to my Minecraft server. When my Minecraft server tries to connect, it says this "Exception during pool initialization: ...
0
votes
0answers
128 views

shell script to input data in a mariadb database

Can't get this script to work #!/bin/bash DB_USER='rb'; DB_PASSWD=''; DB_NAME='demo_db'; TABLE='student'; INPUT_FILE='/full/path/to/data.txt'; LOAD DATA INFILE 'data.txt' INTO TABLE student ...
0
votes
0answers
300 views

How to install older version of mariadb galera cluster to match the running galera cluster versions?

I have following collected deb packages: ~/mariadb_deb_packages$ ll total 18728 drwxrwxr-x 2 ciasto ciasto 4096 Nov 24 22:47 ./ drwxr-xr-x 7 ciasto ciasto 4096 Nov 24 22:44 ../ -rw-r--r-- 1 ...
0
votes
0answers
251 views

Cannot start MariaDB on Ubuntu 20.4 LTS dekstop

● mariadb.service - MariaDB 10.3.25 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor prese> Drop-In: /etc/systemd/system/mariadb.service.d └...
0
votes
0answers
68 views

How to to find and remove (purge) both Mariadb and MySQL?

I'm trying to purge mariadb and mysql: root@mordor:~# root@mordor:~# sudo apt purge mariadb-server-core-10.4 mariadb-server-10.4 mariadb-client-core-10.4 mariadb-client-10.4 Reading package lists......
0
votes
0answers
521 views

How to install ERPnext the easy way?

How can I run the easy install for ERPnext? nicholas@mordor:~/erp$ nicholas@mordor:~/erp$ sudo python3 install.py [sudo] password for nicholas: Logs are saved under /tmp/logs/easy-install__2020-11-...
0
votes
2answers
247 views

Why doesn't MariaDB or MySQL start?

Apparently purging, and/or reinstalling mysql and mariadb can cause conflicts, so tried: root@mordor:~# root@mordor:~# sudo apt purge mariadb-server mariadb-client mysql-client mysql-server Reading ...
0
votes
0answers
182 views

Mysql-server-8.0 fails to install due to existing mysql service in Ubuntu 20.04

I just removed mariadb-server from my Ubuntu 20.04 (MATE). The service does not seem to be running any more, given that mysql client is unable to establish a connection to the localhost server. Then, ...
1
vote
0answers
2k views

Failed to start MariaDB 10.3.25 database server

I have just migrated from mysql to mariadb on Ubuntu 20.04 server with apt install mariadb-server. The installation ended fine, but mariadb-server didn't start. This is the output of the command: ...
0
votes
1answer
367 views

MariaDB Doesn't Start on Kubuntu 20.10

I recently installed MySQL in Kubuntu 20.10. I ended up removing MySQL and installing MariaDB instead because of issues with Akonadi and Kmail not working with MySQL. After installing MariaDB I can't ...
0
votes
0answers
29 views

MariaDB Installation Hassles

Just installed Ubuntu 20.04 after years of using Windows, most lately Win 10. I’m mid-way through creating a repository for MariaDB according to this procedure f The commands dpkg-scanpackages binary /...
0
votes
1answer
71 views

How to deny root mariadb user from sudo?

My root@localhost user has the password, but a sudo-user can access from command line without password, is it possibile to disable this sudo command line access?
0
votes
0answers
64 views

Installed PHPMyAdmin > Restart Apache Fails

I am a bit of a beginner when it comes to ubuntu. But learning as I go, so forgive me if this is a dumb question but I could not find any answers yet online. I just installed phpmyadmin on my ...
0
votes
0answers
19 views

Mariadb and sql changes alt-key/keyboard

I recently downloaded mariadb 15.1 and noticed that every time I use it, it changes the functionality of my alt keys in the terminal that ran mariadb. Normally in the terminal, pressing alt+b should ...
0
votes
0answers
582 views

MariaDB 10.1 on Ubuntu 20.04

Trying to migrate my project to a new server which is running Ubuntu 20.04, Default MariaDB version for 20.04 is MariaDB 10.5. I can't seem to find any details on how to install MariaDB version 10.1 ...
0
votes
1answer
1k views

unknown variable 'pid-file=/run/mysqld/mysqld.pid' when setting 50-server.cnf

I am modifying /etc/mysql/mariadb.conf.d/50-server.cnf When I add the following code, i get the error unknown variable 'pid-file=/run/mysqld/mysqld.pid' [mysql] default-character-set = utf8mb4 I am ...
0
votes
0answers
550 views

How to update MariaDB 10.1 (from Plesk)

I'm stuck with a specific MariaDB version (pre-installed by Plesk) and I can't find a way to upgrade it. Previous attempts already broke my packages and I had to do a full re-install. mysql --version ...
0
votes
1answer
225 views

Mariadb password in Ubuntu 18.04

I setup a password for Mariadb when I ran sudo mysql_secure_installation but when I try to run mariadb with mysql -u root -p I get the following error. ERROR 1698 (28000): Access denied for user 'root'...
1
vote
0answers
54 views

I broke MySQL and can't figure out what's wrong

Ubuntu Server 20.04 Somehow in the course of trying to install phpmyadmin, I broke MySQL and I can't figure out how to fix it. I originally installed the LAMP stack via tasksel. In the course of ...
1
vote
0answers
496 views

Unable to install working MariaDB

I am starting a brand new install on a Proxmox Container (LXC, PVE 5.4). Everything went fine except for MariaDB install. I am using Ansible to install everything, but due to failure, I tried it ...
0
votes
1answer
941 views

Install mariadb 5.5 in ubuntu 20.04

I need to install mariadb 5.5 because I have old databases that wouldn't work with mariadb 10 and cause mysql to crash! I tried adding this repo but no luck sudo sh -c 'echo "deb http://ftp.osuosl....
2
votes
1answer
4k views

Is MariaDB 10.3 compatible with MySQL 8.0.20, dependency check failed

I have installed Ubuntu 20.04 applied Devstack for Openstack application mysql is working: stack@rafael-VirtualBox:~/devstack$ mysql --version mysql Ver 8.0.20-0ubuntu0.20.04.1 for Linux on x86_64 ((...
1
vote
1answer
735 views

How to install phpmyadmin on apache2 ubuntu 20.04 server

I have installed php7, and mariadb. And I have done these steps that written in this document: https://websiteforstudents.com/install-phpmyadmin-on-ubuntu-20-04-18-04-with-apache/ But I couldn't run ...
2
votes
2answers
1k views

Can't Install MySQL after stupid clash with mariaDB

It completely slipped my mind that MySQL was already installed on this particular computer and I installed MariaDB, I was also unaware of the consequences of having both packages on the same computer, ...
2
votes
1answer
5k views

MariaDB: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Main purpose I am trying to install a local version of Prestashop on my ubuntu server 20.04 following those steps. Issue I am currently trying to install MariaDB (Step 5 of the guide) and after trying ...
1
vote
0answers
207 views

Is there no way to install the latest stable MariaDB on Ubuntu 20.04 LTS?

The mariadb repository contains only the beta 10.5 version for 20.04 LTS and in the official ubuntu repository, there is only the old stable 10.3 version. Is there no way to install the current stable ...
0
votes
0answers
80 views

systemctl start does not detach

I got a machine where the settings got changed too much... We try to reanable mariadb-server. Now we got this far, that after systemctl start mariadb.service the service runns. But the terminal is ...

1
2 3 4 5