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@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
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@localhost" instead just creating a user "bugs" -- to mysql, they are different.
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@localhost" instead just creating a user "bugs" -- to mysql, they are different.
-- /\oo/\ / /()\ \ David Mackintosh | dave@xdroop.com | http://www.xdroop.com