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 --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
> sudo add-apt-repository 'deb http://sgp1.mirrors.digitalocean.com/mariadb/repo/5.5/ubuntu trusty main'
> sudo apt-get update 
> sudo apt-get install mariadb-server mariadb-client

This worked great. So, I figured that I'd go ahead and change another server (that I set up a few months ago) so that it would be exactly the same. (It was already running MariaDB.) So, I did the exact same steps -- thinking it would simply upgrade the other server.

But...it created a mess. After quite a bit of hassle, I FINALLY got MariaDB re-installed on the other server...with liberal use of "dpkg --remove --force-depends ..."

Anyway, so now my question is this. Why can't I seem to get both of these servers running the same version as stated on phpMyAdmin? Right now the new server says this on the status page:

Server version: 5.5.41-MariaDB-1~trusty-log - mariadb.org binary distribution
Database client version: libmysql - 5.5.41-MariaDB

...while the old server says this:

Server version: 5.5.40-MariaDB-0ubuntu0.14.04.1 - (Ubuntu)
Database client version: libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: bf9ad53b11c9a57efdb1057292d73b928b8c5c77 $

Everything seems to be working, but it nags at me. The old server has all of the 5.5.41 packages installed (showing below) ...but phpMyAdmin still shows 5.5.40

> sudo dpkg --list | grep -i 'maria'
ii  libmariadbclient18                    5.5.41+maria-1~trusty                amd64        MariaDB database client library
ii  libmysqlclient18                      5.5.41+maria-1~trusty                amd64        Virtual package to satisfy external depends
ii  mariadb-client                        5.5.41+maria-1~trusty                all          MariaDB database client (metapackage depending on the latest version)
ii  mariadb-client-5.5                    5.5.41+maria-1~trusty                amd64        MariaDB database client binaries
ii  mariadb-client-core-5.5               5.5.41+maria-1~trusty                amd64        MariaDB database core client binaries
ii  mariadb-common                        5.5.41+maria-1~trusty                all          MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
ii  mariadb-server                        5.5.41+maria-1~trusty                all          MariaDB database server (metapackage depending on the latest version)
ii  mariadb-server-5.5                    5.5.41+maria-1~trusty                amd64        MariaDB database server binaries
ii  mariadb-server-core-5.5               5.5.41+maria-1~trusty                amd64        MariaDB database core server files
ii  mysql-common                          5.5.41+maria-1~trusty                all          MariaDB database common files (e.g. /etc/mysql/my.cnf)

I feel like perhaps the problem is mysqld-server, etc. didn't really uninstall properly on the old server before I added MariaDB ...but, I swear I followed all of the instructions.

One final bit of information -- on the NEW server:

> sudo service mysql status
 * /usr/bin/mysqladmin  Ver 9.0 Distrib 5.5.41-MariaDB, for debian-linux-gnu on x86_64
Copyright (c) 2000, 2014, Oracle, MariaDB Corporation Ab and others.

Server version          5.5.41-MariaDB-1~trusty-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/run/mysqld/mysqld.sock
Uptime:                 1 hour 2 min 55 sec

Threads: 1  Questions: 124  Slow queries: 0  Opens: 78  Flush tables: 2  Open tables: 51  Queries per second avg: 0.032

On the old server:

> sudo service mysql status
mysql start/running, process 7346

Anyway, if anyone has any thoughts, I'd be curious to hear them. Honestly, what I'd like to do is completely remove MariaDB/MySQL on the old server and start from scratch so that it matches exactly what I have on the new server. But, any time I try to do this ....it just installs the same version as what it had ...it doesn't seem to want to match the new server, even though both are running Ubuntu 14.04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.