2

I'm trying to create an MySQL slave, but I'm not able to grant SUPER,REPLICATION CLIENT to the external powerdns user.

I'm using phpMyAdmin and granted ALL PRIVILEGES to the powerdns user, but it still isn't working..

Command SHOW SLAVE STATUS; on external host/client (=powerdns user):

ERROR 1227 (42000): Access denied; you need the SUPER,REPLICATION CLIENT privilege for this operation

Command SHOW GRANT; on external host/client (=powerdns user):

+-----------------------------------------------------------------------------------------------------------------------------------------------+
| Grants for [email protected]                                                                                                              |
+-----------------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'powerdns'@'xx.xx.xx.xxx' IDENTIFIED BY PASSWORD '*xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' WITH GRANT OPTION |
+-----------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.03 sec)

What I'm doing wrong over here? I'm sure I'm logged to the correct users.

4
  • So you're saying that the remote user logs in, gets that response to SHOW GRANTS;, and then immediately can't run SHOW SLAVE STATUS;? Jan 14, 2014 at 4:28
  • Fixed by copying ROOT..
    – Wouter0100
    Jan 15, 2014 at 8:19
  • Which "ROOT" are you talking about, and how did you "copy" it? Jan 15, 2014 at 11:12
  • root user in phpmyadmin. "Copy user".
    – Wouter0100
    Jan 17, 2014 at 20:53

1 Answer 1

0

Did you as changes to user are not noticed until you do this or login again?

flush privileges;

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .