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...