Is it possible to upgrade MySQL from version 5.7 to version 8.0, with PHP version 5.6.40?

Question

Our Amazon RDS for MySQL DB instances running major version 5.7. The MySQL community deprecated MySQL 5.7 in October 2023 [1], and it will not receive any security patches after October 2023. Therefore, Amazon RDS will end the standard support of MySQL major version 5.7 on February 29, 2024.

Our PHP Current version is 5.6.40, If we update MySQL from 5.7 to 8.0, does it impact on running application with the current PHP version 5.6.40? Do we need to upgrade the PHP Before upgrading the MySQL?

Accepted Answer

Hello.

There are reserved words added in 8.0, so I think that there is a possibility that the MySQL version update will affect you regardless of the PHP version.  
Therefore, we recommend that you create a test environment and check the operation before upgrading the production environment.  
https://dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-new-in-current-series

Is it possible to upgrade MySQL from version 5.7 to version 8.0, with PHP version 5.6.40?

Contenuto pertinente