We have a MySQL database on amazon cloud. Since past 10 days or so I am seeing processes that use MySQL connection (GET connection) fail intermittently with the error
"Error retrieving db data: Access denied for user 'XXXX'@'220.127.116.11' (using password: YES); Caused by: Access denied for user 'XXXXXX'@'18.104.22.168' (using password: YES)".
They run fine few times and fail sometimes with this error. Has anyone seen similar issue?
Could this happen due to frequent backups on MySQL database that could be locking the tables or could it be that mySQL on the cloud is getting dynamic ip address and it sometimes messes up access to the database?