how to change mariadb to mysql ?

[catrung]

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.

 

[zEitEr]

Hello,

I'm not too sure that there is MySQL rpm for CentOS 7 in Directadmin repositories, nevertheless you could try: https://help.directadmin.com/item.php?id=240

 

[catrung]

Hello,

I'm not too sure that there is MySQL rpm for CentOS 7 in Directadmin repositories, nevertheless you could try: https://help.directadmin.com/item.php?id=240

Many thank, i tried and notified:



pls help me to remove mariadb and install mysql.

 

[wattie]

Just a note: Joomla 3 works fine with MariaDB.

 

[catrung]

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

 

[catrung]

Just a note: Joomla 3 works fine with MariaDB.

You using mariadb version ?

 

[zEitEr]

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.

 

[vancanneyt]

As a Joomla user I can confirm it’s compatible with MariaDB 10.x. Haven’t had any issues.

 

[Richard G]

I'm not using MariaDB, but could this be caused by that sudden default "strict" setting in Mariadb I'm reading about?

 

[zEitEr]

Well the only thing I've found, they say:

[FONT=&quot]Joomla is not yet compatible with MySQL 6.x.

here [/FONT]https://docs.joomla.org/Technical_requirements/en
No mention about incompatibilities with MariaDB can be found here https://downloads.joomla.org/us/technical-requirements-us too

 

[vancanneyt]

Interesting read: https://mariadb.com/resources/blog/why-i-moved-my-joomla-website-mariadb

I’m running latest MariaDB release 10.2.9 with Joomla 3.8.1. No issues really . Migrated few years ago and found it to be faster then MySQL. I’m even testing my extensions with the upcoming Joomla 4.x release under MariaDB. Works like a charm.

 

[wattie]

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

 

[mccn]

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

./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

 

[wattie]

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