SOLVED Install MySQL 5.6 instead of MariaDB

[dpsingh]

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]

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]

Officially magento 1.9 doesn't support MariaDB
System Requirements for Magento Enterprise Edition and Community Edition (Current Shipping Versions)

Please also advice me how to disbable Strict Mode

 

[GOT]

Add this to the mysqld section of the /etc/my.cnf

sql_mode=NO_ENGINE_SUBSTITUTION

 

[dpsingh]

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

 

[GOT]

Anywhere in that region is fine.

 

[GOT]

As long as it's under that first line that is.

 

[dpsingh]

Thank you bro you are saviour .

Thanks a lot . You saved my lots of time .

One again thank you .

 

[GOT]

Glad it worked out!

 

[cPanelMichael]

Hello,

I've marked this thread as solved. You can read more about the strict mode changes in MySQL version 5.7 on the thread below:

MySQL 5.5 to 5.7

Thank you.