Show Slave Status not working from console, nor client.
- by Mr. Leinad
Hello,
I have a somewhat strange case.
Whenever one of my coworkers executes this line:
show slave status;
from their MySQL clients, it works smoothly. But if I do that, it says:
ERROR 1227 (42000): Access denied; you need the SUPER,REPLICATION CLIENT privilege for this operation
We are all going against the same database, and if I check privileges I can see:
GRANT ALL PRIVILEGES ON . TO 'usermysql'@'%' IDENTIFIED BY PASSWORD 'password'
There's something wrong with my computer.. but I can't pinpoint where it is..
Thanks
EDIT:
It's kinda bizarre.. it goes through a VPN remotely. But if I change the internet connection, then it works.. If the previous internet connection is restored, it doesn't..
Could we classify this among the great mysteries of the world? Or someone has an idea?