Mantis installation STILL not working

[Kieutrang]

I'm getting the famous Mantis error
Attempting to connect to database as admin BAD. Does administrative user have access to the database? ( No such file or directory )

These are the values I'm using.
Type of Database MySQL
Hostname (for Database Server) mantisbt
Username (for Database) mantisbt
Password (for Database) mantisbt
Database name (for Database) mantisbt
Admin Username (to create Database if required) root
Admin Password (to create Database if required) <<my root password>>

The rest works. I've logged in (via mysql command line) to the database with the username/password and it works. The root password is correct and works.

PLEASE HELP!!!

[cas]

Think your hostname is wrong.
That should have the DNS name of the machine where MYSQL is running.
Is it on the same machine as the webserver, you can use "localhost" or simply put there the ip-address of the machine on which MYSQL is running.

[kkinsey]

If I'm reading this correctly, MantisBT is simply complaining about you using "root" as the database user. This isn't considered a good security practice.

You, or your Database Administrator, should consider creating a MySQL server account for MantisBT to use, with its own passphrase and the appropriate grants/privileges.