MySQL Instance - R1Soft

[Silence12]

Hi,

I'm trying to add a new MySQL instance to CDP (R1soft), i'm adding admin and password to access to mysql, but i'm having some errors, like:

Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Access denied for user 'admin'@'localhost' (using password: YES)

What i need to do to add the instance?

Thanks.

 

[IgorG]

You can refer to KB - http://kb.odin.com/en/116916 for steps to resolve your issue.

 

[Silence12]

Thanks Igor. This really help me in the right direction

regards,

 

[EclipZ]

Would perhaps be better to login to MySQL using admin login , then create a new user login specifically for CDP agent.
In case it helps you or anyone else reading this thread in the future, this is an example that is similar to what we use on our CDP enabled systems for the MySQL agent:


mysql -uadmin -p`cat /etc/psa/.psa.shadow`

GRANT ALL on *.* to cdpagent@'localhost' identified by 'whateverstrongpassyouchoose' ;

FLUSH PRIVILEGES;

quit