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

learn more… | top users | synonyms

1
vote
1answer
14 views

Can I install MySQL and MariaDB both on Ubuntu 16.04 and connection with phpMyAdmin

I have been using MySQL since long but no idea at all about MariaDB and wanted to learn. Before I install MariaDB I would like to know whether it is possible to install along with MySQL and connect it ...
1
vote
2answers
66 views

Not prompted to input the root password when installing mariadb-server on Ubuntu 16.04 LTS

I just had a fresh install on my pc the Ubuntu 16.04 LTS. When I tried to install MariaDB by typing: sudo apt-get install mariadb-server The installation went smoothly but during the process I was ...
0
votes
0answers
16 views

Depends: unixODBC but it is not installable

The following packages have unmet dependencies: mariadb-connect-engine-10.1 : Depends: unixODBC but it is not installable E: Unable to correct problems, you have held broken packages. Two of three ...
1
vote
0answers
16 views

How to restore mysql databases after upgrading to mariadb

While installing mariadb-server, it moved all of my existing databases to /var/lib/mysql-5.7 and created a new /var/lib/mysql folder. How do I restore these databases from the backup folder?
1
vote
1answer
19 views

Drop (copy) Previous mySql Tables Dir into upgrade MariaDB Directory

I've finally moved over to MariaDB from mySql 5.6 on my Ubuntu 16.04 (upgrade from 15.10). I have about a dozen previous web data tables sets (Drupal v7.4x) which are current and still in use on my ...
1
vote
1answer
360 views

Ubuntu 16.04 LAMP MySQL dpkg install problems

LAMP Ubuntu 16.04 MySQL server install problems tried to set up LAMP system on Ubuntu 16.04 with the following instructions. howtoforge ubuntu_lamp_for_newbies Apache and PHP installed and ...
1
vote
2answers
240 views

16.04 MariaDB -> Error in syslog (mysqlcheck)

i've found the following failure in my syslog after installing Ubuntu 16.04 and MariaDB from the Scratch using this really awesome tutorial https://www.howtoforge.com/tutorial/install-apache-with-php-...
1
vote
2answers
3k views

Unable to install MariaDB on Ubuntu 16.04 - unmet dependency

Here are the steps sudo apt-get install software-properties-common sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8 $ sudo add-apt-repository 'deb [arch=...
0
votes
1answer
115 views

Mariadb non-root user

I have installed mariadb and when as a Linux root user, I can run mysql command to access the database. But when I try to login as a normal Linux user and run mysql -u root -p, I am getting error: ...
0
votes
0answers
61 views

debconf-get-selections is not complete

I am researching preseeding/an unattended installation for MariaDB/MySQL. There are many resources online which are covering this procedure. My issue is the following, when I query for example: # ...
0
votes
0answers
64 views

Install bacula on 14.04 while running MariaDB

I tried to install bacula on a 14.04 installation but the installation routine always fails complaining about unmet dependencies. This is because I've installed MariaDB rather than MySQL. Is there any ...
5
votes
1answer
610 views

Why does mariadb keep dying? How do I stop it?

I am running MariaDB 10.0.23-0 on Ubuntu 15.10 as a LAMP server. Running sudo /etc/init.d/mysql start results in: Job for mariadb.service failed because a timeout was exceeded. See "systemctl status ...
0
votes
0answers
56 views

Cannot migrate to MariaDB

I try to "drop-in" migrate to MariaDB from MySQL: sudo apt-get remove --purge mysql-server mysql-client mysql-common sudo apt-get autoremove sudo apt-get autoclean sudo apt-get install mariadb-server ...
0
votes
1answer
198 views

mysql process stopping install as cannot kill

I am trying to install mariadb but install exits as fail as Mysql is running and it cannot stop. MySql is not installed but there is a process running which I cannot kill root@sonic-ubuntu ~ # ps ...
1
vote
1answer
213 views

Unable to uninstall MariaDB [closed]

I tried to re-install MariaDB, I used: sudo apt-get purge mysql* mariadb* But the only package remaining to be un-installed after the failed attempted above is mariadb-server-10.0. When I try to ...
0
votes
2answers
755 views

What is the difference between “systemctl start” and “systemctl enable”?

I installed MariaDB-server to my machine. While setting up I met with a problem whether I have to enable it all the time as the document I follow is given with these steps, sudo yum install mariadb ...
0
votes
0answers
127 views

Mariadb Plugin 'unix socket' is not loaded

After installing Mariadb on Ubuntu 15.10 I was unable to use mysql. The following error was reported: Plugin 'unix socket' is not loaded. It seems that plugin table in the mysql db was empty. Why ...
0
votes
1answer
146 views

apt-get substitute MariaDB in place of MySQL

I am trying to install postfixadmin on Ubuntu. I have MariaDB installed and want to use that as my MySQL database. However, the package dependencies for postfixadmin are MySQL, not MariaDB. Is ...
1
vote
2answers
147 views

How to complete `mariadb-server`'s installation without being stopped at “Enter the password”?

Is there any way to install mariadb-server and auto-set the password for the database? For example: sudo apt-get install -y mariadb-server is to avoid 'Y/N' during the package installation. Now, I ...
0
votes
0answers
69 views

Why does my Ubuntu server shut down the MySQL connection the same time every night?

At the same time every day (around 10 PM EST) my MySQL (now MariaDB) server goes offline and my sites crash. I can't for the life of me figure out why. When I look in the syslog I see that there are ...
2
votes
1answer
2k views

MariaDB 10.1 server won't start after update

Today I ran apt-get upgrade and there was an upgrade for MariaDB 10.1 ob Ubuntu Server 14.04 which failed: Setting up libmysqlclient18 (10.1.9+maria-1~trusty) ... Setting up libmariadbclient18 (10.1....
3
votes
1answer
1k views

Can't login to MySQL as root anymore?

It looks like I can not login to MySQL (actually MariaDB) as root user anymore in Ubuntu 15.04 (I upgraded from 14.04 via 14.10) I already tried to reset the password. What is working, is sudo mysql ...
0
votes
0answers
544 views

How do you fix “unmet dependencies … but [something] is to be installed” error?

I am trying to install and configure an Ubuntu, Django, and MariaDB stack. I have the latest (as of writing) MariaDB 10.0 installed, and as per the Django documentation regarding databases, I am ...
0
votes
0answers
30 views

apt-get upgrade error mysql

I have a PowerDNS cluster with MariaDB. If i do a normal update apt-get update and apt-get upgrade I get this error root@nsauth1:~# apt-get upgrade -y Reading package lists... Done Building ...
3
votes
1answer
233 views

How can I build PHP5 Dependencies while having MariaDB installed?

I am trying to build php5 dependencies on Ubuntu 14.04.2 LTS. Unfortunately I get the following error message. % sudo apt-get build-dep php5 Reading package lists... Done Building dependency tree ...
-1
votes
0answers
899 views

Keystone Identity service: Unable to establish connection

Can someone please help. I've been stuck on this for quite some time now and its frustrating me alot. I cant move forward. keystone tenant-create --name admin --description "Admin Tenant" Unable to ...
0
votes
1answer
784 views

importing mysql backup into a mariaDB instance on ubuntu 14.04

I just installed mariaDB on an ubuntu box using the command: sudo apt-get install mariadb-server per the documentation found here: How to install MariaDB? I have a .sql file that was created on ...
1
vote
1answer
87 views

Error in terminal after installation of MariaDB

W: GPG error: http://ftp.wa.co.za trusty InRelease: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY CBCB082A1BB943DB
1
vote
1answer
50 views

can we install maria db on ubuntu touch device?

can we install maria db server on ubuntu tablet(ubuntu touch) ? i'm trying to install ubuntu touch on a tablet, and i want it to act as portable sql server . is that doable with ubuntu touch
1
vote
0answers
29 views

How do I install MariaDB? [duplicate]

I am new to Ubuntu (it's has been 25 years since I used UNIX in any significant way). I would like to set up MariaDB on both a desktop and server version of Ubuntu 15.04, and I understand MariaDB is ...
0
votes
1answer
250 views

service mysql stop does not work on Ubuntu 15.04

service mysql stop/start (mariadb-server) does nothing on freshly installed Ubuntu 15.04. service apache2 stop works. Also service mysql restart works (after killall mysqld). Any ideas why?
2
votes
1answer
534 views

Can't change open-files-limit for mysql on Ubuntu 14.04

I have a LEMP stack on Ubuntu 14.04 with MariaDB. Mysql is a huge bottleneck for my server. I have tried everything of which I am aware to raise the open files limit for mysql. I have added open-...
3
votes
3answers
11k views

How do I uninstall MariaDB on Ubuntu 14.04 (Trusty Tahr)?

I have installed MariaDB from source and now I need to uninstall it. I used these commands to install it: wget http://mirrors.hustunique.com/mariadb/mariadb-10.0.14/source/mariadb-10.0.14.tar.gz tar -...
0
votes
3answers
663 views

Failed to install MariaDB on Ubuntu 14.10

I'm trying to install MariaDB ob my laptop with Ubuntu 14.10. Every time I'm getting errors. So, the problem is that MariaDB needts libmysqlclient18 version 10.0.16 but 5.x.x is installed. If I'll ...
0
votes
1answer
72 views

MariaDB: problems in installaation to Ubuntu 14.04

This is a very newbie question but I guess it's OK since I am rather new Ubuntu Linux user and now trying to install MariaDB to my computer. I am using Ubuntu version 14.04 and my problem is that ...
1
vote
0answers
367 views

Why are MariaDB versions different with same configurations?

So, last night I install a fresh copy of ubuntu 14.04 and followed some instructions for installing MariaDB as follows: > sudo apt-get install software-properties-common > sudo apt-key adv --...
0
votes
1answer
83 views

oracle mariaDB installation on ubuntu 14.04

How to install oracle mariaBD in ubuntu 14.04 ? please provide me step by step method
1
vote
2answers
3k views

How to install MariaDB on Ubuntu 14.10?

After unsuccessful installation of the latest version of MariaDB through repository that is offered by official page (for Ubuntu 14.04) I've tried to install mariadb-5.5 which is already included in ...
1
vote
2answers
2k views

mariadb 10 install error on ubuntu 14.04

when trying to install mariadb on ubuntu 14.04 dpkg: error processing archive /var/cache/apt/archives/libmysqlclient18_10.0.14+maria-1~trusty_amd64.deb (--unpack): libmysqlclient18:amd64 10.0.14+...
14
votes
2answers
10k views

How to Drop-In replace MySQL with MariaDB?

I already have several MySQL DBs running on my Ubuntu 14.04 Server, and I would like to migrate these as smoothly as possible to the compatible MariaDB. I'm also using PHPMyAdmin. Is there a different ...
1
vote
1answer
974 views

MrSID support for QGIS 2.4 in Ubuntu 14.04

I am trying to get MrSID support in QGIS 2.4 in Ubuntu 14.04. According to the this tutorial you have to rebuild libgdal against MrSID SDK from LizardTech. But I cannot find the package libgdal-mrsid-...
2
votes
1answer
9k views

mariadb new install : Checking for corrupt, not cleanly closed and upgrade needing tables

I installed mariadb-server. never installed before mysql. /var/lib/mysql was empty. # apt-get install mariadb-server blah~blah~ # service mysql restart * Stopping MariaDB database server mysqld ...
1
vote
1answer
674 views

apt-get upgrade not fully installed but is ok, how to remove?

We use mariadb with galera. All works well, but every time we upgrade with sudo apt-get upgrade it thinks it fails to upgrade mariadb-server, but it does work fine. I think the issue is caused because ...
8
votes
5answers
47k views

Installing Mysql Workbench on ubuntu 14.04

I have installed MariaDb as its supported by Ubuntu community , mentioned in release note of latest LTS. After that I tried to install Mariadb-client , that too installed successfully, after that its ...
0
votes
0answers
26 views

Installing MariaDB on ubuntu 14.04 [duplicate]

How can install MariaDb on ubuntu 14.04 , i have searched in Ubuntu Software Center but its not there. Then checked MariaDB official website but its clearly mentioned there are some issues in .deb ...
1
vote
0answers
1k views

How to investigate mariadb unixODBC issue further [closed]

I've been using mariadb for a while on Ubuntu 12.04 with an ODBC DSN that I could use in R. Today it stopped working and I've been checking things like reinstalling packages, moving to mariadb 10 (as ...
1
vote
1answer
116 views

Installing MariaDB fails

I am trying to solve this GitHub issue (Vaprobash). (If you got Vagrant setup then you could try it out yourself and see the error in more detail.) The script I am using can be found here: mariadb.sh ...
0
votes
1answer
490 views

aptitude problem using mariadb repository on Ubuntu 13.10

I installed mariadb 5.5 on my ubuntu laptop like described here: sudo add-apt-repository "deb http://ftp.osuosl.org/pub/mariadb/repo/5.5/ubuntu $(lsb_release -c -s) main" and it works fine so far, ...
4
votes
2answers
2k views

How to stop dist-upgrade from removing MariaDB?

A similar question was asked at Partial upgrade - why remove MariaDB?. The answer to that question basically was stating that dist-upgrade is the issue. This question is asking if there is some ...
0
votes
1answer
911 views

Problems during installation of MariaDb on Ubuntu 12.04

I'm trying to install MariaDB according to this documentation: sudo apt-get install python-software-properties sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 ...