Show Slave Status not working from console, nor client.
        Posted  
        
            by Mr. Leinad
        on Server Fault
        
        See other posts from Server Fault
        
            or by Mr. Leinad
        
        
        
        Published on 2010-03-10T18:29:02Z
        Indexed on 
            2010/04/22
            14:03 UTC
        
        
        Read the original article
        Hit count: 319
        
mysql-replication
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?
© Server Fault or respective owner