Hello.
> GRANT ALL ON *.* TO 'test'@123.123.123.123' IDENTIFIED BY 'h4x0r' Are you sure that you are connected as [EMAIL PROTECTED] user? What does 'status' command report (execute it in the mysql command line client)? What version of MySQL do you use? "Morten Kalles$e" <[EMAIL PROTECTED]> 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.=20 > > 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' > > Shouldnt 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 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]