Page 1 of 1

Attempting to connect to database as admin BAD

Posted: 31 Aug 2005, 20:10
by wolfhard
Ladies and gentlemen,

Could someone please help me understand the difference between ..
Database Username/ Password and Admin Username/ Password??

I get the error below when trying to install Mantis ..

Setting Database Hostname GOOD
Setting Database Type GOOD
Checking PHP support for database type GOOD
Setting Database Username GOOD
Setting Database Password GOOD
Setting Database Name GOOD
Setting Admin Username GOOD
Setting Admin Password GOOD
Attempting to connect to database as admin BAD
Does administrative user have access to the database?

Thank you.
Kind regards
Wolfhard Aring

Attempting to connect to database as admin BAD

Posted: 31 Aug 2005, 20:15
by wolfhard
MySQL 4.0.25
PHP 5.0.4
Mantis 1.0.0rc1
Windows 2003 Server

Attempting to connect to database as admin BAD

Posted: 31 Aug 2005, 21:21
by wolfhard
Where can I find this file?

db_generate.sql

Please ..

Posted: 01 Sep 2005, 02:01
by thraxisp
See http://www.futureware.biz/blog/index.ph ... &tb=1&pb=1 for an explanation of the two user ids. If you assign all mysql privileged to a database user, you can just enter the name once in the database user/password.

The error you are seeing means that this user can't access the Mysql database. It may be an incorrect hostname in the access specification.

The db_generate.sql file is obsolete now.

Posted: 26 Mar 2006, 15:03
by cussuol
I have this problem too.

But I just don't have an user able to create de database. It's a restriction from my ISP provider.

However, I have an empty fresh and new database and I user with full right to it.

I'd like the mantis instalations process skip the database creation step and just build the database estruture inside it.

Is it possible?

Posted: 29 Mar 2006, 05:40
by dcomo
What you actually need is a schema dump. No data, just the database parameters that you can import into MySQL via command prompt of PHPMyAdmin.

Let me see if I can get you one shortly...

Solution

Posted: 29 Mar 2006, 05:52
by Cybeer
write this in your mysql console:
set password for username@localhost = OLD_PASSWORD('password');