Mysql – Show Slave Status not working from console, nor client

MySQLmysql-replication

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?

Best Answer

MySQL distinquishes between localhost and 'other' systems.

GRANT ALL PRIVILEGES ON . TO 'usermysql'@'%' IDENTIFIED BY PASSWORD 'password'

gives the 'others' access. To give the system where the database is running access you'll need to also grnat permission to localhost:

GRANT ALL PRIVILEGES ON . TO 'usermysql'@'localhost' IDENTIFIED BY PASSWORD 'password'
Related Topic