I've been beating my head on the desk all evening trying to get Zabbix up and running on a CentOS 7 VM. I kept seeing the above error in the log file. And I knew my password was correct, and I could log into MySQL as that user, run queries, etc.
I finally figured out what it was. And I am posting this up just in case someone else runs into it.
I had a # in my MySQL password. Since I had a # in my password, I thought I would be clever and surround it in single quotes in the DBPassword entries of the different conf files because the # is a comment character. That didnt work. I am thinking it was sending the single quotes along as well to MySQL.
So, just to put this out there, make sure your passwords have acceptable characters for both the conf files and MySQL. Dont use # characters! =)
Now to start getting configuring collecting stats....
I finally figured out what it was. And I am posting this up just in case someone else runs into it.
I had a # in my MySQL password. Since I had a # in my password, I thought I would be clever and surround it in single quotes in the DBPassword entries of the different conf files because the # is a comment character. That didnt work. I am thinking it was sending the single quotes along as well to MySQL.
So, just to put this out there, make sure your passwords have acceptable characters for both the conf files and MySQL. Dont use # characters! =)
Now to start getting configuring collecting stats....