User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20021003 Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20021003 In the Bugzilla-Guide in section: 4.1.8. Setting Up the MySQL Database Here is the GRANT command: mysql> GRANT SELECT,INSERT,UPDATE,DELETE,INDEX, ALTER,CREATE,DROP,REFERENCES ON bugs.* TO bugs@localhost IDENTIFIED BY '<bugs_password>'; mysql> FLUSH PRIVILEGES; The bugs user also needs LOCK TABLE privileges. Reproducible: Always Steps to Reproduce: 1.Install New MySQL 4 2.Install Bugzilla following directions 3. View new bugzilla directory Actual Results: A server error occurs instead of the page being displayed. Expected Results: Bugzilla default page should show up. Error log from apache: DBD::mysql::st execute failed: Access denied for user: 'bugs@localhost' to database 'bugs' at globals.pl line 271. [Tue Apr 22 11:30:58 2003] query.cgi: DBD::mysql::st execute failed: Access denied for user: 'bugs@localhost' to database 'bugs' at globals.pl line 271. Uncaught exception from user code: LOCK TABLES shadowlog WRITE, tokens WRITE: Access denied for user: 'bugs@localhost' to database 'bugs' at /usr/lib/perl5/5.6.1/CGI/Carp.pm line 301. CGI::Carp::realdie('LOCK TABLES shadowlog WRITE, tokens WRITE: Access denied for us...') called at /usr/lib/perl5/5.6.1/CGI/Carp.pm line 372 CGI::Carp::die('LOCK TABLES shadowlog WRITE, tokens WRITE: Access denied for us...') called at globals.pl line 276 main::SendSQL('LOCK TABLES tokens WRITE') called at Token.pm line 158 Token::CleanTokenTable() called at globals.pl line 624 main::GetVersionTable() called at /var/www/html/bugzilla/query.cgi line 190 [Tue Apr 22 11:30:58 2003] [error] [client 192.168.2.41] Premature end of script headers: /var/www/html/bugzilla/query.cgi

you need to give lock privs, too *** This bug has been marked as a duplicate of 195424 ***

This note will be in the updated docs that should appear on bugzilla.org sometime this evening.