Issue Add external Percona DB from Docker

[Puma7]

Hi,

i tried to ad a Percona DB which is running in a Docker as an external DB. For some reasen it always fails.
If I use a MariaDB in a Docker it works with localhost or 127.0.0.1
Is there any differnece in adding Percona as external DB than a MariaDB?

 

[FISHeR]

Hi,

there should be no differences. I checked the main scenario: added Percona as an external database and I had no problems.

At what step do you have a problem? What error is displayed? Maybe you have 2 databases running on the same port?

 

[Puma7]

Hi,

i get following message:

Error: The test connection to the database server has failed:

SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client

This happends if I use Host 127.0.0.1 with localhost I get a different message:

DB query failed: SQLSTATE[HY000] [1524] Plugin 'unix_socket' is not loaded

But I have no problem to connect via MySql Workbench

 

[FISHeR]

Hi,

the root cause is that caching_sha2_password as the preferred authentication plugin is used (applicable to MySQL 8 & Percona 8).

Read more here: MySQL :: MySQL 8.0 Reference Manual :: 2.11.4 Changes in MySQL 8.0