Access denied for user 'otrs'@'localhost' (using password: Y

[Harikumar]

Hi Team,

I tried to install OTRS3.2.3 using the windows installer.But after installation,when i opened the browser,it is showing as
Access denied for user 'otrs'@'localhost' (using password: YES).Would some one please help me how to get rid off this issue and make me login.

Thanks in advance

[crythias]

otrs/Kernel/Config.pm holds the credentials for the database.
If you've used http://yourhost/otrs/installer.pl to configure the system, Config.pm should reflect the credentials you've provided through the web interface.

I don't know how you've set this up, and I don't use OTRS on Windows, so I don't have a better answer than this.

[ianatschool]

I had this issue when upgrading on Windows. I think the below is what you need.

Launch command prompt and change directory to mysql bin
mysql –uroot –p (hit enter and at the password prompt hit enter. If you have set a password for mysql then input it but by default it is blank I think)
GRANT ALL PRIVILEGES ON otrs.* TO otrs@localhost IDENTIFIED BY “databasepassword” WITH GRANT OPTION;
Type exit and type the next command.
mysqladmin –u root –p reload. At the password prompt hit enter. Again if you have a password for mysql then enter it, if not it will be blank.

Hope it works for you