Monitoring mysql without Agent or root access

[Stefan_x96]

Hello,
I am trying to monitor databases I have on Hetzner ConsoleH.

I have full privilege Mysql user, but that is about it. I have no SSH Access and cannot install Zabbix Agent.
Is there a way I can monitor the Databases?

Thank you for your help

[brunohl]

Hello,

If the user is able to login remotely yeah, you could monitor your database from another agent.

[kloczek]

Hello,
I am trying to monitor databases I have on Hetzner ConsoleH.

I have full privilege Mysql user, but that is about it. I have no SSH Access and cannot install Zabbix Agent.
Is there a way I can monitor the Databases?

https://github.com/kloczek/zabbix-templates/tree/master/Service%20MySQL

[dbatechnologies]

If mysql user you have can log in from zabbix server, then you can write or find php script, which would log in and get required statistics. It can be either achieved by issuing mysql commands or by querying performance schema. Check on zabbix share.

[Stefan_x96]

Thank you got answers brunohl kloczek dbatechnologies ,
I set it up to just show me if it is up or down with this scrypt:

#!/bin/bash

HOST=$1

ping -c1 $HOST 1>/dev/null 2>/dev/null
SUCCESS=$?

if [ $SUCCESS -eq 0 ]
then
#  echo "$HOST is up!"
echo "1"

else
 # echo "$HOST is down!!"
echo "0"

fi
#EOF

And setup an item as an external check for every item with:

script.sh["example.com"]

, together with a trigger:

{Zabbix server:script.sh["example.com"].last(0)}=0

I think it is working fine to say if something fails, but I am having an issue to set up a graph, I want to see on Dashboard listed all hosts with info (up or down), is there a chance someone can help me with this?
Thanks a lot in advance