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: 263

Filed under:

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

Related posts about mysql-replication