Trouble setting up MySQL monitoring

[aimrabbit004]

⚠️ Please verify that this bug has NOT been raised before.

• I checked and didn't find similar issue

🛡️ Security Policy

• I agree to have read this project Security Policy

📝 Describe your problem

I added a MySQL monitor by using the given syntax like mysql://user:password@host:port/database but I get this error message:
Server requests authentication using unknown plugin . See TODO: add plugins doco here on how to configure or author authentication plugins.

MySQL Server Version: mysql Ver 14.14 Distrib 5.1.73

What should I do to get it working?

Thanks for helping.

🐻 Uptime-Kuma Version

1.21.0-beta1

💻 Operating System and Arch

Ubuntu 20.04 x64

🌐 Browser

Mozilla Firefox 110.0.1

🐋 Docker Version

No response

🟩 NodeJS Version

14.21.3

[aimrabbit004]

Okay found the solution.
sidorares/node-mysql2#1021 (comment)

ALTER USER 'user'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

Change the password to a long hash and it will connect.
For generating the hash I used: https://www.browserling.com/tools/mysql-password