MySQL 5.1.66 cannot grant monitoring user to check SLAVE STATUS - Source

Revision: 74469
User: Alex Sem
Date: 2019-05-13 10:46

--------------------------------------------------

Problem Summary
---------------------------------------------------
MySQL 5.1.66 cannot grant monitoring user to check SLAVE STATUS

Problem Description
---------------------------------------------------

Good morning,
i need help in order to grant a monitor user to check the slave status in a master-salve replication.
This is the error and the activity done to solve without success, the issue:

<<code>>
MariaDB [(none)]> show slave status\G

ERROR 1227 (42000): Access denied; you need the SUPER,REPLICATION CLIENT privilege for this operation

MariaDB [(none)]> exit

Bye

MariaDB [(none)]> GRANT SUPER, RELOAD, PROCESS, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO zabbix@'%';

Query OK, 0 rows affected (0.00 sec)
<</code>>

- Login with user zabbix:
<<code>>
mysql -S /mysql/mysql.sock -u zabbix -p

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 205415

Server version: 5.1.66-MariaDB-log (MariaDB - http://mariadb.com/)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> show slave status\G

ERROR 1227 (42000): Access denied; you need the SUPER,REPLICATION CLIENT privilege for this operation

MariaDB [(none)]> exit
<</code>>
- Granted user zabbix with grant full privileges:
<<code>>
GRANT ALL PRIVILEGES ON *.* TO zabbix@'%';

MariaDB [(none)]> show slave status\G

ERROR 1227 (42000): Access denied; you need the SUPER,REPLICATION CLIENT privilege for this operation
<</code>>

It is a bug of older version?
If i do the same on MySQL 5.7 the monitoring user can check the slave status.

Answer

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

MySQL 5.1.66 cannot grant monitoring user to check SLAVE STATUS - Source

Answer

Products

Services

Pricing

Resources

About Us

Download MariaDB