MySQL 5.6 to 5.7 upgrade seemless?

Scott Galambos

• October 10, 2020 11:54

Is there anything I should know before I do this? My cPanel server wants to update my MySQL from 5.6 to 5.7.

• 

  andrew.n

  • October 10, 2020 17:00

  Yes! If you go to MySQL Upgrade on the left and choose the new version then click on Next you will see all the warnings you should consider before upgrading it :)

  0
• 

  cPJeremy

  • October 10, 2020 19:52

  Hello @Scott Galambos ! Firstly, I did want to mention that andrew.n is correct. When you use WHM and select the new version you would like to install, there are some warnings that you will have to manually agree to before upgrading. This will give you an opportunity to ensure your sites may be compatible. However, one thing I did want to mention is that one issue that users can encounter when upgrading from MySQL 5.6 to 5.7 are issues with MySQL's "Strict Mode." There are some changes that are enabled by default in MySQL 5.7. Specifically, the SQL mode "Strict Trans Tables" being enabled. Depending on how some sites were developed to use MySQL, some sites may not work properly if "Strict Trans Tables" is enabled. I wanted to include another forums thread for reference. Even though this thread below is for a user going from MySQL 5.5 to 5.7, the information in the thread is still helpful.

  0
• 

  Scott Galambos

  • October 11, 2020 02:24

  great, thanks for your help.

  0

Please sign in to leave a comment.