Not the answer you need?
Register and ask your own question!

"access denied" failure

pblazekpblazek EntrantCurrent User Role Supporter
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:[email protected](127.0.0.1:3306)...
MySQL connection OK
Creating new MySQL user for agent...
Agent MySQL user: percona-agent:[email protected](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 [EMAIL="percona-agent@127.0.0.1"][email protected][/EMAIL], which I modified to [EMAIL="percona-agent@localhost"][email protected][/EMAIL] due to the error message I was receiving. I have verified the password hash. I have also added a duplicate user [EMAIL="percona-agent@127.0.0.1"][email protected][/EMAIL] with the same password hash and privileges (SUPER, PROCESS). What have I missed?

Comments

  • kamil-dziedzickamil-dziedzic Entrant Inactive User Role Beginner
    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.
  • pblazekpblazek Entrant Current User Role Supporter
    Done - thanks.
  • RuskicowboyRuskicowboy Entrant Current User Role Beginner
    I'm getting the same thing. Will request support.
  • aleoycdvaleoycdv Entrant Current User Role Beginner
    Maybe is because the root permissions have been lost... you would have to check it,
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.