Access denied for user 'otrs'@'localhost' (using password: YES) RemoteAddress: ::1 RequestURI: /otrs/index.pl Traceback (10404): Module: Kernel::System::DB::new (OTRS 3.2.12) Line: 225 Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.12) Line: 140 Module: PerlEx::Precompiler::c_::otrs::otrs::bin::cgi2dbin::index_pl::__ANON__ (unknown version) Line: 41 Module: (eval) (unknown version) Line: 458 Module: PerlEx::Precompiler::Execute (unknown version) Line: 458

Well, I had just finish the installation of OTRS (wich is a software I'l try to use as change management system) when I received this error

Oops! An Error occurred.
 Error Message: Access denied for user 'otrs'@'localhost' (using password: YES)
 Please contact your administrator.
You can Send a bugreport or go back to the previous page.
Error Details
Backend ERROR: OTRS-CGI-10 Perl: 5.16.3 OS: MSWin32 Time: Tue Nov 5 15:30:47 2013 Message: Access denied for user 'otrs'@'localhost' (using password: YES) RemoteAddress: ::1 RequestURI: /otrs/index.pl Traceback (10404): Module: Kernel::System::DB::new (OTRS 3.2.12) Line: 225 Module: Kernel::System::Web::InterfaceAgent::Run (OTRS 3.2.12) Line: 140 Module: PerlEx::Precompiler::c_::otrs::otrs::bin::cgi2dbin::index_pl::__ANON__ (unknown version) Line: 41 Module: (eval) (unknown version) Line: 458 Module: PerlEx::Precompiler::Execute (unknown version) Line: 458

Delightful, isn't it?

Well, how fix it?

1 - Go to command prompt of mysql and give the grant to otrs

mysql> GRANT ALL PRIVILEGES ON *.* TO 'otrs'@'localhost'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

2 - Be sure it worked.

SHOW GRANTS FOR 'otrs'@'localhost';

restart OTRS.