GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

"access denied" failure

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • "access denied" failure

    I have just removed 1.0.3 and installed 1.0.4 on a server. I get:

    Warning 2014-07-10 13:16:09 mm-mysql-db1.towxchange.net Failed to connect to MySQL after 1 tries (Error 1045: Access denied for user 'percona-agent'@'localhost' (using password: YES))

    every couple of minutes in the log. Here is a snippet from the install:

    Create MySQL user for agent? ('N' to use existing user) (Y):
    Specify a root/super MySQL user to create a user for the agent
    MySQL username: root
    MySQL password:
    MySQL host[: port] or socket file (localhost): 127.0.0.1
    Testing MySQL connection root:...@tcp(127.0.0.1:3306)...
    MySQL connection OK
    Creating new MySQL user for agent...
    Agent MySQL user: percona-agent:0xc2080297a02596996162@tcp(127.0.0.1:3306)/?parseTime=true


    As you can see, I specified 127.0.0.1 as the host. The installer created a user percona-agent@127.0.0.1, which I modified to percona-agent@localhost due to the error message I was receiving. I have verified the password hash. I have also added a duplicate user percona-agent@127.0.0.1 with the same password hash and privileges (SUPER, PROCESS). What have I missed?

  • #2
    Hi pblazek,

    Could you request support from our web interface on cloud.percona.com? After you login, please use a "Support" button which is at the bottom of the page and include all above details in the message.

    Comment


    • #3
      Done - thanks.

      Comment


      • #4
        I'm getting the same thing. Will request support.

        Comment


        • #5
          Maybe is because the root permissions have been lost... you would have to check it,
          Last edited by scott.nemes; 08-28-2014, 02:25 PM. Reason: Removed link

          Comment

          Working...
          X