Hi,
It’s caused of special character in your mysql’s password.
There have 2 solutions that I have solved.
1. Change you mysql password not to use character like &%*)%
2. If you don’t want to change password try to use single quote in password term like this
./adduser.php user ‘yourpa$$word’ 1
Best Regards.
From: observium-bounces@observium.org [mailto:observium-bounces@observium.org] On Behalf Of Ben .T.George
Sent: Sunday, April 14, 2013 1:35 PM
To: observium@observium.org
Subject: [Observium] adduser.php giving mysql error
HI Mailing List
i followed http://www.observium.org/wiki/RHEL_SVN_Installation this tutorial.
when i run ./adduser.php <username> <password> 1
i am getting mysql error like below
<h2> observer MySQL Error</h2> Access denied for user 'USERNAME'@'localhosr ' (using password: YES)
for me the below mysql table creation and access giving was successful. I used below command
mysql -u root -p
<mysql root password>
mysql> CREATE DATABASE observium;
mysql> GRANT ALL PRIVILEGES ON observium.* TO 'observium'@'localhost'
-> IDENTIFIED BY '<observium db password>';
Thanks & Regards,
Ben