App service cannot connect to database: ERROR 08S01 (1043): Bad handshake

Marc de Jong 20 Reputation points
2023-02-11T12:10:22.1733333+00:00

Our app service is suddenly not able to connect to the database anymore.

App service gives the following log:

2023-02-11T12:05:43.842683709Z throw new PrismaClientInitializationError(error2.message, this.config.clientVersion, error2.error_code);

2023-02-11T12:05:43.842690510Z ^

2023-02-11T12:05:43.846452593Z Error: Error querying the database: Server error: `ERROR 08S01 (1043): Bad handshake'

I've tried restarting everything, but to no avail

Anyone got suggestions on what to do?

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
986 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,930 questions
{count} votes

2 answers

Sort by: Most helpful
  1. 浜田 茂雄 0 Reputation points
    2023-02-14T02:33:06.6333333+00:00
    0 comments No comments

  2. Guillaume 0 Reputation points
    2023-02-15T17:44:56.49+00:00

    Same here,

    Everything was working fine this morning on MYSQL v8.0.29 after the maintenance updating to MySQL v8.0.31,
    I was suddenly, without changing the code or some settings, not able to connect to my database locally and from my production server... I spent my day with support ! Raise your hand if you experiment the same problem it will help


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.