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
41 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
29 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....
1
vote
1answer
140 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 ...
0
votes
1answer
69 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
164 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
115 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 ...
0
votes
0answers
20 views

sudo apt, dpkg and mariadb problems [duplicate]

when i run sudo apt upgrade,sudo apt-get -f install,sudo dpkg --configure -a ,sudo systemctl status mariadb i am getting errors like : E: Could not get lock /var/lib/dpkg/lock - open (11: Resource ...
1
vote
0answers
159 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
27 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
vote
1answer
31 views

Ubuntu not booting, displaying mariadb server error

After rebuilding docker Ubuntu stopped booting and showing this with blinking monitor Error I tried enter ubuntu advanced mode and remove maria-db with following commands, but nothing helped apt-get ...
1
vote
0answers
19 views

apt-key returns invalid argument

The following command in Ubuntu 18.04 on a DO droplet is returning the error 'Invalid argument': apt-key adv --fetch-keys 'https://mariadb.org/mariadb_release_signing_key.asc' I've checked the ...
0
votes
0answers
31 views

MariaDB works very slow on localhost if connected to internet

I am running working on a local installation of Wordpress on my Ubuntu 19.10. I have MariaDB installed as database. It was working fine till few days ago that I noticed when I am connected to internet,...
1
vote
0answers
406 views

Why does MariaDB installation last for a long time?

Installation of mariaDB lasted for a long time, ending the terminal process. $ sudo apt-get install mariadb-server mariadb-client Attempting to install MariaDB again caused the following problems: ...
1
vote
1answer
138 views

Where is file binary and library of mariadb and mysql?

I want to clearly remove mariadb on ubuntu 18.04, and reinstall it again. But I have problems when trying it. To remove mariadb clearly, I run this command as root apt-get purge mariadb-server ...
0
votes
0answers
21 views

Unable to LOAD_FILE in MariaDB with Ubuntu 1804

So the question is related to this other one : https://stackoverflow.com/questions/60470783/unable-to-load-file-in-maria-db Basically LOAD_FILE is returning null even though i should be able to use ...
0
votes
0answers
6 views

Ubuntu desktop utility for mysql or Mariadb connection

I am looking for the Ubuntu desktop utility for MySQL or Mariadb connection. Do you have any program advice that works seamlessly with Ubuntu in this regard? I am looking for a program like dbeaver ...
1
vote
1answer
31 views

Can I install multiple database management systems on a same machine having ubuntu 18.04?

I currently have Postgresql installed on my system but I also want to install mariadb on my system. So I want to know is that okay or it will show errors after installing mariadb. Thanks
1
vote
1answer
244 views

Downgrade Mariadb to 10.1 on Ubuntu 19.10

I recently upgraded my main Ubuntu install from Ubuntu 18.04 to 19.10 mainly for testing within my company to make sure the currently used software stack will be compatible come 20.04 Everything is ...
0
votes
1answer
524 views

MariaDB bind-address not updating?

I'm trying to set the bind-address of my MariaDB installation to 0.0.0.0 to allow external connections. I edited /etc/mysql/mysql.conf.d/mysqld.cnf and updated the [mysqld] section to the following: ...
2
votes
1answer
74 views

Unable to reinstall MySQL after mistakenly installing MariaDB

I did not realize that installing MariaDB would overwrite so much of MySQL, and make it unusable--I didn't know they were so similar. I'd prefer to stay with MySQL, but when attempting to fix my ...
1
vote
1answer
234 views

How do I authenticate with ed25519 using the MariaDB client?

Whilst launching MariaDB via Docker using MYSQL_ALLOW_EMPTY_PASSWORD I was prompted to run /usr/bin/mysql_secure_installation. This makes sense but (like others) I prefer configuring things non-...
6
votes
1answer
2k views

Ubuntu Terminal: “apt-get” invalid syntax

I have just recently installed Ubuntu onto my new laptop, following all steps correctly during installation, installing new applications and drivers from online. Upon finishing installing Ubuntu, I ...
0
votes
0answers
24 views

Importing raw mysql files

Please do not mark this as a duplicate, I've tried all the other threads and they have not helped me. So basically, I installed MariaDB (was installing dependencies for Pterodactyl) which for some ...
1
vote
0answers
119 views

mysqld won't start, apparmor blocked some file?

I'm using ubuntu 19.10,and when I installed mariadb, it is fine but when I restart the computer it started got some error. I track down the error seems like apparmor blocked it from reading some file. ...
0
votes
0answers
91 views

Have MySQL and MariaDB on the same server using apt?

Looking to have a local testing server using Ubuntu. I would like to have both MySQL and MariaDB on this server, at the same time (Different ports, obviously). Is it possible to install both using ...
0
votes
1answer
155 views

PHP curl module not recognised

I am installing https://github.com/pH7Software/pH7-Social-Dating-CMS On a virgin Ubuntu 18.04 server. I am going by this guide Nginx, php 7.3 (Maria DB). It all went well, the installation script ...
0
votes
0answers
74 views

How to install libmariadb2 on ubuntu 18.04

I'd like to use Teamspeak 3 with Mariadb on ubuntu 18.04. Teamspeak hasn't yet released Teamspeak 5 and so the ts3-Server stilll needs libmariadb2 to be abele to connect mariadb-server. The server I ...
0
votes
0answers
48 views

Ubuntu 18.04: Ubuntu stuck on startup (Mariadb Failed, Network time Sycronization Failed)

I have installed MariaDB 10.4 on Ubuntu 18.04 when I restart the system it stuck on startup showing two errors [FAILED] Failed to start MariaDB 10.4.8 database server [FAILED] Failed to Start ...
0
votes
2answers
1k views

MariaDB fails despite apparmor profile

Starting MariaDB fails on my Ubuntu 19 installation after this: nov 02 16:40:51 farnsworth systemd[1]: Starting MariaDB 10.3.17 database server... nov 02 16:40:51 farnsworth mysqld[5328]: 2019-11-02 ...
2
votes
1answer
871 views

18.04 - Not able to connect to mysql

So I've been trying to setup my new work development system, I have gotten everything installed and setup properly except MySQL. I've been trying everything I can even think of to gain access to mysql ...
1
vote
1answer
1k views

How to run mysql_upgrade when using xampp?

Ubuntu 16.04 64 bit, unity, latest version of xampp. How to run mysql_upgrade -u root -p I tried running it in home directory and /opt/lampp/bin and /opt/lampp/, nothing worked.
0
votes
1answer
245 views

Error found when loading /etc/profile [mariadb,mysql]

Booting to Ubuntu 19.04 I get black screen (frozen and not able to press the OK button) with this error message popup: Error found when loading /etc/profile find:'/usr/lib/mysql/plugin/...
0
votes
1answer
103 views

How to drop a table within a database in a single line, scheduled from crontab?

I am trying to drop an entire table within a database. My intention is simple, and I wish for this to happen occasionally through a scheduled crontab command. For now, I have this example cronjob ...
0
votes
0answers
22 views

Ubuntu Studio upgrade from 18.10 to 19.04 trashed MariaDB database?

After upgrading Ubuntu Studio from 18.10 to 19.04, I am no longer able to access an existing MariaDB database. On examination, the database and associated user account no longer exist. Did this update ...
0
votes
0answers
13 views

mariadb on ec2 problem [duplicate]

I installed apache2, mysql, and phpmyadmin smoothly in ec2 and I want to install mariadb but it gives me the following error : The following packages have unmet dependencies: Reading package lists......
0
votes
0answers
43 views

Please Help, I Can not install any updates or upgrade to a new release, After grep removing all traces of “mysql” & “mariadb”

Okay; so about 7 months ago, I installed Ubuntu for the first time ever. I was having some fun with Zoneminder, then I decided to try installing Shinobi. I screwed up a database somewhere / somehow ...
0
votes
1answer
139 views

Upgrade from 16.04 to 18.04 wants to remove MariaDB Server

I have a VPS with Ubuntu 16.04 that I use as webserver and Nextcloud Server. I want to upgrade my VPS to Ubuntu 18.04. As I do do-release-upgrade It tells me that if I agree to proceed it would ...
1
vote
0answers
812 views

MariaDB won't work after reboot

I'm trying to get mariadb 10.3 to work on a fresh installation of ubuntu server 16.04 which comes with mysql 5.7 so I've started by stopping and removing it using sudo service mysql stop sudo apt-...
2
votes
0answers
1k views

How can I configure apparmor to allow mariadb load a shared library?

After a routine update yesterday, MariaDB would not start because a shared library file is not loading because it is being blocked by apparmor. Here's the output from the journalctl -xe Apr 17 11:44:...
-1
votes
2answers
396 views

Install MariaDB 10.0 on Ubuntu 18.04

I'm relatively new to the Linux. Can anyone please help me how to install MariaDB version 10.0 and not newer?
0
votes
1answer
238 views

Mariadb server error

I'm trying to rationalize my mariadb installation. (I've tried uninstall and reinstalling and may need to dig deeper to reset it correctly) When I run 'systemctl status mariadb' the follow is ...
0
votes
0answers
500 views

After rebooting the system, MariaDB does not start?

Начат процесс запуска юнита mariadb.service. апр 02 08:41:35 doox911 audit[3334]: AVC apparmor="DENIED" operation="open" profile="/usr/sbin/mysqld" name="/sys/devices/system/node/" pid=3334 comm="...
0
votes
1answer
977 views

MariaDB 10.3.3 Galera cluster adding new node in existing cluster # WSREP: Waiting for SST to complete

I am trying to add new galera cluster node in existing MariaDB Master-Master setup, but i am seeing SST waiting for longer time and mariadb services failing to start. services status output as below, ...
1
vote
1answer
164 views

MariaDB: Default password authentication not good enough?

I've been researching for a couple of hours the "best practice" to create a second account for the mysql database using password authentication instead of the auth_socket / unix_socket. By this guide ...
1
vote
1answer
239 views

Galera cluster load balancer deployment

We have multiple website connecting to a single server running MariaDB - 10.3.11and due to heavy load, we decided to implement Galera Cluster replication, which has been implemented and we got the ...
0
votes
1answer
3k views

mysqldump: Error 2013: Lost connection to MySQL server during query when dumping table

Recently, i was trying to make a slave working by dumping via ssh the databases. I had discart percona-xtrabackup because i liked to select which databases i'de like to sync. For make the slave work,...
3
votes
1answer
3k views

Migration from MariaDB to MySQL

The question is simple: Which is the painless way to migrate from MariaDB to MySQL? I was thinking about make a complete dump of the databases and import it on the new DB, but having the possibility ...
1
vote
2answers
3k views

No root user password for MariaDB

I've gone through the process of installing MariaDB several times now, and it has never asked me to create a root password. The upshot of this is I can't get in and create the database. Obviously I'...
0
votes
1answer
2k views

Remove Mariadb 10.3 and Mysql completely from Ubuntu

I have been trying to remove all the package. apt-get remove --purge mysql* apt-get remove --purge mysql apt-get remove --purge mariadb apt-get remove --purge mariadb* apt-get --purge remove mariadb-...
0
votes
1answer
4k views

MariaDB installation error: Unable to correct problems, you have held broken packages

I am trying to install MariaDB following the official site but I keep getting errors. First step: $ sudo apt-get install software-properties-common Reading package lists... Done Building dependency ...