Add support for monitoring MySQL/MariaDB databases

[derekoharrow]

⚠️ Please verify that this feature request has NOT been suggested before.

• [X] I checked and didn't find similar feature request

🏷️ Feature Request Type

New Monitor

🔖 Feature description

PR1430 has just added the ability to monitor MS SQL Server DB's.

It would be good to also be able to monitor other popular DBs too - specifically MySQL/MariaDB which many people use.

✔️ Solution

Replicate the setup for MS SQL server, but with different connection methods and parameters to connect and test MySQL/MariaDB

❓ Alternatives

Currently doing a TCP Port test, but this only checks if the port is open, not whether a DB is actually available on that port and functioning.

📝 Additional Context

No response

[Iliannnn]

Would be very helpful

[tieb62]

Yes because SQL check does not work for MySQL

[Computroniks]

I will have a look at implementing this tonight

[tieb62]

Thanks

[tieb62]

And a Good Idea would be to make clear that SQL monitor is in fact "MS SQL" Monitor, because it's really confusing

[Computroniks]

I have implemented this in #2151. If anyone is able to help test this it would be greatly appreciated.