Install MySQL 5.6 instead of MariaDB

dpsingh

• April 11, 2019 02:40

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

  • April 11, 2019 12:52

  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.

  0
• 

  dpsingh

  • April 12, 2019 05:03

  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

  0
• 

  GOT

  • April 12, 2019 12:33

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

  0
• 

  dpsingh

  • April 13, 2019 09:13

  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

  0
• 

  GOT

  • April 13, 2019 11:22

  Anywhere in that region is fine.

  0
• 

  GOT

  • April 13, 2019 11:23

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

  0
• 

  dpsingh

  • April 13, 2019 14:32

  Thank you bro you are saviour . Thanks a lot . You saved my lots of time . One again thank you .

  0
• 

  GOT

  • April 13, 2019 14:59

  Glad it worked out!

  0
• 

  cPanelMichael

  • April 15, 2019 19:38

  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:

  0

Please sign in to leave a comment.