Mysql_native_password is deprecated and will be removed in a future release

Get Help CMS Installation
1

CMS Version

  • ghcr.io/xibosignage/xibo-cms:release-3.3.8
  • ghcr.io/xibosignage/xibo-xmr:0.11
  • docker.io/mysql:8.0.35

Installation Method

Docker 24.0.7

Operating System

Debian 12

Issue

After the MySQL Upgrade from 5.7.44 to 8.0.35 the log gets filled with this:

2023-11-09T07:17:02.302789Z 141766 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:02.431784Z 141767 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:02.513106Z 141768 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:02.762387Z 141769 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:02.848983Z 141770 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:03.015695Z 141771 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:03.088651Z 141772 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:04.321374Z 141773 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:04.830451Z 141774 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:04.948144Z 141775 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:05.045127Z 141776 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:05.155129Z 141777 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:05.423031Z 141778 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:05.527484Z 141779 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:05.660881Z 141780 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:05.743446Z 141781 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:05.836216Z 141782 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:05.920934Z 141783 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:06.428231Z 141784 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:06.546120Z 141785 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:06.558149Z 141786 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:06.673119Z 141787 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:07.412569Z 141788 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:07.467168Z 141789 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2023-11-09T07:17:07.523078Z 141790 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

Can this be fixed by updating the used MySQL client library (xibosignage/xibo-cms) or do we need to fix this manually somehow?

Resources:

2

Hi @yalla-bra ,

Only MySQL 5.7 is officially supported for v3 CMS instances.

Kind Regards,

Frazer

3

Hello @Frazer

Good to know, thx for the information.

So we will not see this kind of logs messages using version 4.0.x right?

4

Xibo CMS 4.x uses PHP 8.2 which I do believe supports MySQL 8’s new default caching_sha2_password.

5

Hey,
i get this warnings and have installed php8.2.12. Xibo Version 4.0.5.

Any Solutions?

6

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.