Morten Kallesøe wrote: > Hi > > I have been trying to get my mysql server to do as i want, but its not > quite playing along. > > I need to monitor the replication status from a remote server, first by > hand, 2nd by a perl script. > > But i keep getting this darn message. > > mysql> show master status; > ERROR 1227: Access denied. You need the SUPER,REPLICATION CLIENT privilege > for this operation > > I have made a user with the following command: GRANT ALL ON *.* TO > 'test'@123.123.123.123' IDENTIFIED BY 'h4x0r' > > Shouldn't that be enough? Or am i just missing something, > > I have also tried to make the user with: GRANT SUPER,REPLICATION CLIENT TO > 'test'@'123.123.123.123' IDENTIFIED BY 'h4x0r'; No luck there ethier. > > Regards Morten
First, verify you are connected as the correct user: mysql> SELECT CURRENT_USER(); If that shows 'test'@123.123.123.123', then verify your GRANT worked: mysql SHOW GRANTS FOR 'test'@123.123.123.123'; If the solution is still not apparent, include the output in your next message. Michael P.S. I hope 'h4x0r' isn't really the password. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]