SOLVED Install MySQL 5.6 instead of MariaDB

dpsingh

Registered
Apr 11, 2019
4
0
1
India
cPanel Access Level
Root Administrator
OS : Centos 7.6 KVM
WHM : v78.0.20

I am running magento 1.9.x & it supports only MySQL 5.6 (Oracle or Percona) . The problem is cpanel by default installs the MariaDB so can you tell me how i can install the MySQL 5.6 & remove the MariaDB .

Please tell me the step by step command i am not so expert in linux . I am just newbie .
 

GOT

Get Proactive!
PartnerNOC
Apr 8, 2003
1,739
301
363
Chesapeake, VA
cPanel Access Level
DataCenter Provider
I've never seen cPanel install MariaDB by default. These days it installs MySQL 5.7 if nothing is customized on the install. Perhaps your host did this for you. I know when we deploy new servers we normally upgrade mysql to MariaDB unless told specifically not to.

We have a number of clients running Magento on MariaDB though. You may want to give it a go. Worst case you might have to disbable Strict Mode if you are running 10.2 or higher.

Downgrading MySQL is not going to be an option for you I'm afraid, unless you want to dump all your databases, uninstall mysql, delete the data folder and the force cPanel to roll back the version. Its messy, but possible.

I'd advise trying to get MariaDB working though.
 

dpsingh

Registered
Apr 11, 2019
4
0
1
India
cPanel Access Level
Root Administrator
Thank you brother for so much helping nature .

Can you tell me where should i have to write that line . I have these things in my config file

[mysqld]
log-error=/var/lib/mysql/{servername}.err
performance-schema=0
default-storage-engine=MyISAM
innodb_file_per_table=1
max_allowed_packet=268435456
open_files_limit=10000
query_cache_type=1
query_cache_limit=1M
query_cache_min_res_unit=2k
query_cache_size=128M
innodb_buffer_pool_size=2G
tmp_table_size=64M
max_heap_table_size=64M



where should i have to put sql_mode=NO_ENGINE_SUBSTITUTION