Share via

Troubleshooting SQL Mode Issues When Upgrading to MySQL 8.0 on Azure

GeethaThatipatri-MSFT 29,477 Reputation points Microsoft Employee
2024-07-26T21:34:25.1333333+00:00

I encountered issues while upgrading my SQL database to MySQL 8.0 on Azure. How can I resolve the problem related to SQL modes?

PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
848 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,477 Reputation points Microsoft Employee
    2024-07-26T21:36:51.01+00:00

    Greetings!

    When upgrading your SQL database to MySQL 8.0 on Azure, certain SQL modes set on the server parameters might cause issues. Follow these steps to resolve the problem:

    1. Go to your server parameters settings.
    2. Locate the sql_mode parameter.
    3. Uncheck all the parameters under sql_mode.
    4. Attempt the upgrade to MySQL 8.0 again.

     

    These changes help to bypass the SQL modes that might be causing conflicts during the upgrade process. Once you have unchecked the parameters, the upgrade should proceed without issues.

     Hope this helps. If you have any follow-up questions, please let me know. I would be happy to help.

     

    Please do not forget to "up-vote" wherever the information provided helps you, as this can be beneficial to other community members.

    Regards

    Geetha

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.