privileges - SUPER,REPLICATION CLIENT prev to external MySQL user

06
2014-04
  • Wouter0100

    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.

    • Answers
    Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

    Related Question

    MySQL Replication on Linux
  • sjain

    I am doing MysqlReplication on Linux/Debian I have installed mysql.

    Now the first setp for mysql replication is to edit the /etc/mysql/my.cnf file. But that is not available in the location.

    So how can I edit that ?

    Any Idea?

    Thanks.


    • Related Answers
  • matthias krull

    I suggest you run:

    updatedb
locate my.cnf

    If you installed mysql manually the files may be installed under the PREFIX directory. That is usually /usr/local or the location you chose.

    which mysql

    Maybe helps finding the prefix dir.

    If there is still no my.cnf to be found you can find a lot of example my.cnf files for nearly every possible case on the googlenet.

  • Janne Pikkarainen

    Just create the file with the text editor of your choice.