Replacing mysql with MariaDB

Question

I am new to Linux and servers. I was using mysql 5.5 (was installed using third party repositories) as my DBMS and then I decided to replace it with the latest version of MariaDB.

I executed following commands to stop and delete the mysql:

service mysqld stop
yum -y remove mysql*

then I added MariaDB repositories for my OS (CentOS 6 - 64bit) to the yum. Installed it using:

yum install -y MariaDB-server MariaDB-client MariaDB-devel

started it with:

service mysql start

and it successfully started.

Then when I opened phpMyAdmin I recognized it is still connecting to mysql5.5 ! and also from php scripts it seems it is still connecting to that older mysql! I tried to stop mysqld but it told me there is no such service!

When I execute :

mysql -V
mysql  Ver 15.1 Distrib 10.1.14-MariaDB, for Linux (x86_64) using readline 5.1

I am really confused. Can you please help me what happened and how can I fix it ?

Yes I am aware of that . But the server version is not the same ! Please look at the picture I linked at top and the version I get with mysql -V — BlackBrain, Jun 02 '16 at 19:38
Perhaps phpMyAdmin was using cached values from your previous install? — Thomas N, Jun 02 '16 at 19:48
@ThomasN if this is the case where can I delete the cached values ? — BlackBrain, Jun 02 '16 at 20:04

score 0 · Accepted Answer · answered Jun 02 '16 at 22:57

0

phpMyAdmin isn't connecting to a service that doesn't exist. Assuming that netstat -tulpn shows that MariaDB is listening on port 3306, those scripts are reporting an incorrect version (As MariaDB is a MySQL fork) or a cached version (Look at Thomas N's comments).

If you want to be 100% sure, just perform a change in phpMyAdmin and use the mysql command line tool to connect to the MariaDB database and verify it changed.

answered Jun 02 '16 at 22:57

ConnorJC

939
1
8
20

It was fixed automatically. I did not do any change so I think it was cached. – BlackBrain Jun 03 '16 at 07:00

Replacing mysql with MariaDB

1 Answers1