Error: Can't connect to database

[chadrolfs]

When I try to install the database I get past the second screen but always stop on the third screen with this:

---------

Error: Can't connect to database, read comment!
Comment: Access denied for user 'root'@'localhost' (using password: NO)
Bug Report:
Traceback: ERROR: OTRS-Installer-10 Perl: 5.8.8 OS: linux Time: Fri Jul 9 13:33:18 2010

Message: Can't connect to database, read comment!

Traceback (23775):
Module: Kernel::Output::HTML::Layout::Error (v1.176.2.17) Line: 1416
Module: Kernel::Output::HTML::Layout::ErrorScreen (v1.176.2.17) Line: 1395
Module: Kernel::Modules::Installer::Run (v1.58) Line: 221
Module: main::GenericModules (v1.31) Line: 130
Module: /opt/otrs/bin/cgi-bin/installer.pl (v1.31) Line: 91
------------

I saw earlier on the forum a post that was similar that said to accept the default password on screen two which I did but I still get the error. I am using version 2.4.7 on CentOS. Any help you can provide is greatly appreciated.

thanks
Chad

[crythias]

MySQL root must have its own password for your installation and you told OTRS installation there was no password for root.

[chadrolfs]

Thank you for your prompt response crythias. I made a root password, however I still get a similar error:

Error: Can't connect to database, read comment!
Comment: Access denied for user 'root'@'localhost' (using password: YES)
Bug Report:
Traceback: ERROR: OTRS-Installer-10 Perl: 5.8.8 OS: linux Time: Sat Jul 10 17:39:52 2010

Message: Can't connect to database, read comment!

Traceback (31589):
Module: Kernel::Output::HTML::Layout::Error (v1.176.2.17) Line: 1416
Module: Kernel::Output::HTML::Layout::ErrorScreen (v1.176.2.17) Line: 1395
Module: Kernel::Modules::Installer::Run (v1.58) Line: 221
Module: main::GenericModules (v1.31) Line: 130
Module: /opt/otrs/bin/cgi-bin/installer.pl (v1.31) Line: 91

As always, any help you can provide is greatly appreciated!

thanks
Chad

[crythias]

Comment: Access denied for user 'root'@'localhost' (using password: YES)

Wrong password provided for root ('root'@'localhost') . You *might* have to \escape certain special characters like $. (th\!\$Way) or make an alphanumeric only password, but make certain it's for 'root'@'localhost'.
For others who might have issues with MySQL root passwords, please check the MySQL documents for explicit instructions.