how to change mariadb to mysql ?

catrung

Verified User
Joined
Oct 31, 2016
Messages
13
I can't install joomla 3 on server because mariadb set as default on centos7, how to change mariadb to mysql ? pls help me. Tks.
Capture.PNG
Capture.PNG
 
Last edited:
Just a note: Joomla 3 works fine with MariaDB.

Great info but are you absolutely sure about that?

I tried install joomla 2.5 : at the first screen i to choice language and press next step then waiting forever...
Joomla 3: not see database infomation at the tab connection database
 
I doubt that MariaDB is not compatible with Joomla.

MariaDB is official replacement of MySQL in CentOS 7.

If you want to remove MySQL from CentOS use yum/rpm to remove its rpm`s. Please search the forums and help sections for details.
 
As a Joomla user I can confirm it’s compatible with MariaDB 10.x. Haven’t had any issues.
 
I'm not using MariaDB, but could this be caused by that sudden default "strict" setting in Mariadb I'm reading about?
 
Great info but are you absolutely sure about that?

100%. Joomla 1, 2 & 3 all work fine under MariaDB 10.2.

I recently upgraded three websites from Joomla 1.0.15 to the latest 3.8. This involved intermediate steps: 1 -> 1.5 -> 2.5 -> 3.8
 
Last edited:
Hello i have problem after change mariadb to mysql

First remove maria db after https://help.directadmin.com/item.php?id=240
To mysql 5.7


My problem after change:

Column count of mysql.user is wrong. Expected 45, found 48. The table is probably corrupted

Code:
./build mysql
        Dumping database da_roundcube
        Dumping database mysql
        Dumping database test
Cannot find libnuma.so.1, installing using apt-get...
Reading package lists... Done
Building dependency tree
Reading state information... Done
libnuma-dev is already the newest version (2.0.11-2.1).
libnuma1 is already the newest version (2.0.11-2.1).
0 upgraded, 0 newly installed, 0 to remove and 54 not upgraded.
mv: 'mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz' and '/usr/local/mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz' are the same file
Stopping mysqld ...
Ensuring local-infile is disabled for security reasons in MySQL configuration file...
Giving mysqld a few seconds to start up...
Checking if update is needed.
Running queries to upgrade MySQL server.
mysql_upgrade: [ERROR] 1136: Column count doesn't match value count at row 1
Restarting MySQL.


Please help me ;)

Sorry for my bad english
 
Run this command to repair all databases (sh shell):

/usr/local/mysql/bin/mysqlcheck -uda_admin -p`grep "^passwd=" /usr/local/directadmin/conf/mysql.conf | cut -d= -f2` --auto-repair=TRUE --all-databases=TRUE
 
Back
Top