My hosts file has only one entry 127.0.0.1 ip-myip.ip.secureserver.net ip-myip localhost.secureserver.net localhost.localdomain localhost -----Original Message----- From: plug-discuss-bounces@lists.plug.phoenix.az.us [mailto:plug-discuss-bounces@lists.plug.phoenix.az.us] On Behalf Of David Sent: Monday, February 04, 2008 4:09 PM To: Main PLUG discussion list Subject: Re: MySQL - Bugzilla help ----- "Bryan O'Neal" wrote: > Ok, I am trying to install bugzilla, but I am getting an error when I > run ./checksetup.pl as apache Enter the e-mail address of the > administrator: > bryan@loopadvertising.com > > Enter the real name of the administrator: Bryan ONeal Enter a password > for the administrator account: > Please retype the password to verify: DBD::mysql::db do failed: > Access > denied for user 'bugs'@'localhost' to > database 'bugs' at Bugzilla/DB/Mysql.pm line 209 > > Bugzilla::DB::Mysql::bz_lock_tables('Bugzilla::DB::Mysql=HASH(0xb2d3bc > c) ', 'profiles WRITE', 'profiles_activity WRITE', 'user_group_map > WRITE', 'email_setting WRITE', 'groups READ', 'tokens READ', > 'fielddefs > READ') > called at Bugzilla/User.pm line 1548 > Bugzilla::User::create('Bugzilla::User', 'HASH(0xb3e0f78)') > called at Bugzilla/Install.pm line 330 > Bugzilla::Install::create_admin() called at ./checksetup.pl > line > 214 > > So I decided to check out the DB but I was denied access. > > As MySQL root I set up permissions prior to executing the install > script. > mysql> GRANT SELECT,INSERT,UPDATE,DELETE,INDEX, > ALTER,CREATE,DROP,REFERENCES ON bugs.* TO bugs@localhost > IDENTIFIED BY 'SomePassword'; > mysql> FLUSH PRIVILEGES; > > Then I ran the script which gave me the above error. So I decided to > cheek out the DB. As root I executed mysql -u=root (I did not get a > password prompt, which I thought was way odd since I have set the root > password) > > mysql> show databases; > +--------------------+ > | Database | > +--------------------+ > | information_schema | > | test | > +--------------------+ > 2 rows in set (0.00 sec) > > > Note, that the database bugs is not listed. However it is in the > system somewhere > mysql> create database bugs; > ERROR 1044 (42000): Access denied for user ''@'localhost' > to database 'bugs' > mysql> GRANT SELECT,INSERT,UPDATE,DELETE,INDEX, > ALTER,CREATE,DROP,REFERENCES ON bugs.* TO bugs@localhost > IDENTIFIED BY 'SomePassword'; ERROR 1044 > (42000): Access denied for user ''@'localhost' > to database 'bugs' > > > I am not very failure with BugZilla.. Any suggestions on how to get > rid of this error and continue installation? > Not sure which distro you're using, but if it's redhat, check your /etc/hosts file. They've been known to do some funky things to is. David -- "I find your lack of faith disturbing." --Darth Vader --------------------------------------------------- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss --------------------------------------------------- PLUG-discuss mailing list - PLUG-discuss@lists.plug.phoenix.az.us To subscribe, unsubscribe, or to change your mail settings: http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss