I am able to logon with user 'bugs' and passwd 'marvin' as below: [EMAIL PROTECTED] root]# mysql -u bugs -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 4.0.20-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> I noticed before the MySQL installed - when I do a 'which mysql' I get output of '/usr/local/mysql/bin/mysql' - but now I get /usr/bin/mysql. But why does bugzilla checksetup.pl failed to connect to the database in error below.. Checking user setup ... Precompiling templates ... DBI connect(';localhost;3306','bugs',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at ./checksetup.pl line 1189 [Thu Jul 1 12:32:14 2004] checksetup.pl: DBI connect(';localhost;3306','bugs',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at ./checksetup.pl line 1189 <h1>Software error:</h1> <pre>Can't connect to the mysql database. Is the database installed and up and running? Do you have the correct username and password selected in localconfig? AHA </pre> <p> For help, please send mail to this site's webmaster, giving this error message and the time and date of the error. </p> [Thu Jul 1 12:32:14 2004] checksetup.pl: Can't connect to the mysql database. Is the database installed and [Thu Jul 1 12:32:14 2004] checksetup.pl: up and running? Do you have the correct username and password selected in [Thu Jul 1 12:32:14 2004] checksetup.pl: localconfig? AHA [Thu Jul 1 12:32:14 2004] checksetup.pl: [EMAIL PROTECTED] bugzilla-2.16.5]# -----Original Message----- From: Hassan Schroeder [mailto:[EMAIL PROTECTED] Sent: Thursday, July 01, 2004 11:52 AM To: [EMAIL PROTECTED] Subject: Re: bugzilla not working now after MySQL re-installed Nguyen, Long P (Mission Systems) wrote: > I tried this and get a 0 affect below.. > > mysql> GRANT SELECT,INSERT,UPDATE,DELETE,INDEX, ALTER,CREATE,DROP,REFERENCES ON > bugs.* TO [EMAIL PROTECTED] IDENTIFIED BY 'marvin'; > Query OK, 0 rows affected (0.00 sec) OK, I assume 'bugs' and 'marvin' are the values in bugzilla's config file; can you log in from the MySQL client using them instead of the root user/pwd? -- Hassan Schroeder ----------------------------- [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]