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 >