"access denied" failure

Polyglot Projects Percona Cloud Tools
1

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.

3

Done - thanks.

4

I’m getting the same thing. Will request support.

5

Maybe is because the root permissions have been lost… you would have to check it,