Questions tagged [mariadb]

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

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

Mariadb-server and mariadb-client

I have ben trying to install mariadb-server and mariadb-client on my ubuntu 18.04 VPS, but when I run apt install -y mariadb-server mariadb-client it returns: Reading package lists... Done Building ...
user avatar
1 vote
1 answer
34 views

Help Setting Up a MariaDB server

I am trying to setup a MariaDB but I can't figure out what's wrong Installation Prosses I did the following commands: sudo apt update sudo apt install mariadb-server sudo mysql_secure_installation ...
user avatar
1 vote
1 answer
214 views

Is it possible to install mariadb 10.3 or mysql 5.7 in Ubuntu 22.04?

I need to install mariadb 10.3 or mysql 5.7 to work with Magento 2.3 project, but I am not able to do this via apt install. It installs only the latest versions of the soft above. I tried to add ...
user avatar
  • 13
0 votes
0 answers
55 views

Cannot install mysql in Ubuntu 20.04 LTE

I've been struggling to install mysql server in Ubuntu 20.04. I did have mariadb installed previously. No matter which post or guide I follow, I always wind up getting this message when I try to ...
user avatar
0 votes
0 answers
68 views

ubuntu server down unexpectedly

I have worked on ubuntu server through remote login ,the problem is that whenever server it's because of MySQL [MariaDB 10.3]running on my server. How to fix MySQL issue? I have checked error log ,...
user avatar
  • 11
3 votes
1 answer
2k views

Unable to start mariadb service on WSL2 (Win10) Ubuntu 22.04

I'm trying to run the mariadb service on Ubuntu 22.04 on WSL2 but with no success. The MariaDB service could not be started. Environment: Microsoft Windows [Version 10.0.19044.1645] WSL2 with Ubuntu-...
user avatar
  • 133
0 votes
2 answers
823 views

Akonadi on KDE can't start due to "Unknown error" and I can't update MariaDB

Konact / KMail does not want to start anymore, because Akonadi fails. I am not able to start akonadi ~$ akonadictl --verbose start Connecting to deprecated signal QDBusConnectionInterface::...
user avatar
  • 389
0 votes
1 answer
1k views

Unable to install mariadb-server on ubuntu 22.04

I am trying to install mariadb-server on ubuntu 22.04 LTS but I am getting an dependency error message related to galera-4 & libssl. How to fix this issue ? Reading package lists... Done Building ...
user avatar
  • 73
0 votes
1 answer
129 views

Cant start mysql

When i try to run sudo service mysql start it just kinda "loads" no output or nothing. nothing is shown in the error logs. sudo service mysql status mariadb.service - MariaDB 10.3.32 ...
user avatar
  • 1
0 votes
0 answers
48 views

system root is only user that can login to mariadb

This is a weird one (for me). If I sudo -s into root user I can login to mariadb using any account I've created but if I try to login as my standard user using mysql -u root -p I get Access denied ...
user avatar
0 votes
1 answer
433 views

Unable to install mariadb-server on Ubuntu 20.04.4 LTS

I followed this article to install mariadb on Ubuntu 20.04.4 LTS. However, I was shown these messages Reading package lists... Done Building dependency tree Reading state information... Done Some ...
user avatar
0 votes
2 answers
646 views

Uninstall MariaDB without removing databases

I am running MariaDB 10.3 on Ubuntu 20.04. Now MariaDB is not running and one database in it. Can I uninstall the MariaDB 10.3 retaining database? My plan is that install a higher version of MariaDB ...
user avatar
0 votes
0 answers
27 views

mariadb 10.6 server and client installation ubuntu 20.04 The repository __ does not have a Release file [duplicate]

In a computer with ubuntu 20.04, I can not install mariadb-server and client. I execute the following command: sudo apt-get install software-properties-common dirmngr apt-transport-https -y && ...
user avatar
  • 135
0 votes
1 answer
863 views

Unable to install MySQL

I am totally new to using Ubuntu. I don't even know a single command to run. I'm trying to install MySQL but an error is always there. I ran this command: sudo apt-get install mysql-community-client-...
user avatar
0 votes
2 answers
75 views

PHP connection to Maria DB

Hopefully someone can explain an issue I found doing a simple connection between PHP 7 and MariaDB Server 10.3.32 on Ubuntu 20.04. Here is the connection data: $dsn = "mysql:localhost; dbname=...
user avatar
  • 5
0 votes
0 answers
155 views

Set Root Password During MariaDB 10.6 Install on Ubuntu Server 20.04

The last version of MariaDB I had installed on Ubuntu Server 20.04 was 10.3.32 through their own repositories. I was using the following set of commands (as root): apt-key adv --fetch-keys 'https://...
user avatar
0 votes
1 answer
169 views

Restore root login via 'sudo mariadb' command

After mysql_secure_installation, sudo mariadb command does not seem to work anymore with the following error: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Does ...
user avatar
  • 59
0 votes
1 answer
181 views

Ubuntu 21.10, mariadb update failure

Here is the error message: Setting up mariadb-common (1:10.5.13-0ubuntu0.21.10.1) ... update-alternatives: error: alternative path /etc/mysql/mariadb.cnf doesn't exist dpkg: error processing package ...
user avatar
  • 31
1 vote
1 answer
69 views

What is enabling mariadb on first boot

A bit of background on what I'm trying to do: We are building an Ubuntu image that we deploy to thousands of workstations. We need to have MariaDB available on the workstations, but we only want it ...
user avatar
1 vote
1 answer
1k views

MariaDB Won't Start After Installing

I'm running an Ubuntu 20.4 server and I've recently removed mysql-server and mysql-client and am trying to get MariaDB up and running. I've installed both mariadb-server and mariadb-client. I stop and ...
user avatar
0 votes
0 answers
1k views

mysql debian-start[190181]: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I am trying to set up MariaDB server under xubuntu 20.04 and import all the db's I had previously on another machine under xubuntu 18 (following the notes I took when doing it there coming from ...
user avatar
1 vote
1 answer
1k views

Can't install mariadb-server - unmet dependancy mariadb-server

I was following a setup process of the ERPNext from here in a fresh Ubuntu 20.04 server but I'm stuck at command sudo apt -y install mariadb-server libmysqlclient-dev as I can't install mariadb in it. ...
user avatar
0 votes
2 answers
710 views

Attempting to install mariadb-server on Ubuntu server 21.04 throws an error

When I try to install mariadb-server on Ubuntu 21.04 using: sudo apt install mariadb-server It shows this error: Reading package lists... Done Building dependency tree Reading state ...
user avatar
0 votes
0 answers
238 views

Unable to Install Mariadb 10.2.2 or later on Ubuntu 18.04 LTS(32Bit) fom mariadb sources

I've migrated from Ubuntu 16.04 LTS 32bit to 18.04 LTS. Since 18.04 installs Mariadb 10.1.48, have added following Mariadb 10.2 repository to /etc/apt/sources.list , after updating the following is ...
user avatar
  • 1
0 votes
0 answers
48 views

Something is wrong with timezone on mariadb

I am having an issue about the time displayed on a table. In mariadb, I created a table that has id, name ,gender, created_at and updated_at. The table looks like this +----+--------+--------+------+--...
user avatar
  • 1
2 votes
2 answers
1k views

/usr/sbin/mysqld: error while loading shared libraries: liblz4.so.1: cannot open shared object file: No such file or directory

p2@P2:~$sudo systemctl restart mariadb Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe"...
user avatar
  • 21
1 vote
0 answers
37 views

MariaDB 10.2 on Ubuntu 20.04 [duplicate]

Can you please let me know why MariaDB has not released a Mariadb 10.2 official repository for ubuntu 20.04? Does that mean that we cannot install Mariadb 10.2 on Ubuntu 20.04? MariaDB 10.2 and ...
user avatar
1 vote
0 answers
226 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 ...
user avatar
0 votes
0 answers
81 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-...
user avatar
0 votes
0 answers
241 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 ...
user avatar
1 vote
3 answers
7k 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,...
user avatar
0 votes
0 answers
80 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 ...
user avatar
  • 1
0 votes
1 answer
182 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:
user avatar
  • 1
0 votes
0 answers
130 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 ...
user avatar
0 votes
1 answer
76 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 ...
user avatar
0 votes
0 answers
31 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 ...
user avatar
0 votes
1 answer
2k 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 ...
user avatar
0 votes
0 answers
29 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 ...
user avatar
1 vote
1 answer
538 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 ...
user avatar
  • 5
0 votes
0 answers
23 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. ...
user avatar
2 votes
1 answer
4k 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 ...
user avatar
0 votes
1 answer
320 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 ...
user avatar
2 votes
1 answer
5k 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), ...
user avatar
  • 299
0 votes
1 answer
168 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 ...
user avatar
0 votes
1 answer
2k 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/...
user avatar
0 votes
1 answer
116 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).
user avatar
  • 105
1 vote
1 answer
915 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 ...
user avatar
3 votes
1 answer
4k 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 ...
user avatar
0 votes
0 answers
137 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: ...
user avatar
0 votes
0 answers
539 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 ...
user avatar

1
2 3 4 5