Scott Ehrlich
2007-Nov-23  13:59 UTC
[CentOS] Bugzilla Install problems - need last mile help
I've freshly installed CentOS 5 32-bit on a pc, performed a yum update and
yum
upgrade.   I then did a yum install of mysql.
I finally picked up fresh copies of phpmysql and bugzilla and put both in my 
/var/www/html directory.   mysql is running.  I am able to use mysql -u root to 
get into it, and phpmysql is able to get it, too.
After runs of checksetup.pl to ensure all required pre-requisites were 
installed, I ran it one more time, and get the following:
Creating database bugs...
The 'bugs' database could not be created. The error returned was:
     Access denied for user ''@'localhost' to database
'bugs'
This might have several reasons:
* MySQL is not running.
* MySQL is running, but there is a problem either in the
   server configuration or the database access rights. Read the Bugzilla
   Guide in the doc directory. The section about database configuration
   should help.
* Your password for the 'bugs' user, specified in $db_pass, is
   incorrect, in './localconfig'.
* There is a subtle problem with Perl, DBI, or MySQL. Make
   sure all settings in './localconfig' are correct. If all else fails,
set
   '$db_check' to 0.
[root at localhost bugzilla]#
What do I need to do next?   I tried creating an empty database called bugs for 
the script to hook into, but no luck.  I tried creating a user bugs with full 
permission, but no luck.
Thanks for any leads.
Scott
David Mackintosh
2007-Nov-23  16:51 UTC
[CentOS] Bugzilla Install problems - need last mile help
On Fri, Nov 23, 2007 at 08:59:43AM -0500, Scott Ehrlich wrote:> Creating database bugs... > The 'bugs' database could not be created. The error returned was: > > Access denied for user ''@'localhost' to database 'bugs'I've seen this problem before, but I can't find my notes on it. Try creating a user "bugs at localhost" instead just creating a user "bugs" -- to mysql, they are different. -- /\oo/\ / /()\ \ David Mackintosh | dave at xdroop.com | http://www.xdroop.com -------------- next part -------------- A non-text attachment was scrubbed... Name: not available Type: application/pgp-signature Size: 189 bytes Desc: not available URL: <http://lists.centos.org/pipermail/centos/attachments/20071123/14331e59/attachment-0005.sig>
Scott Ehrlich
2007-Nov-23  17:00 UTC
[CentOS] Bugzilla Install problems - need last mile help
Wow! Using phpmyadmin, new user bugs, hostname localhost, no associated database (let check script handle that) and it went through! Now I have to debug wny http://localhost/bugzilla/index.cgi produces the contents of the index.cgi file instead of the proper page. Scott On Fri, 23 Nov 2007, David Mackintosh wrote:> On Fri, Nov 23, 2007 at 08:59:43AM -0500, Scott Ehrlich wrote: >> Creating database bugs... >> The 'bugs' database could not be created. The error returned was: >> >> Access denied for user ''@'localhost' to database 'bugs' > > I've seen this problem before, but I can't find my notes on it. > > Try creating a user "bugs at localhost" instead just creating a user > "bugs" -- to mysql, they are different. > > -- > /\oo/\ > / /()\ \ David Mackintosh | > dave at xdroop.com | http://www.xdroop.com >