Installation Problem with Bugzilla - Access denied for user ''@'localhost' to database 'bugs'

I have the same problem as the person before me - earlier in the
conference.

Bugzilla script can not create database 'bugs'.

I created two MySQL users: bugs and bugs@localhost and gave them full
permissions.
I edited file LOCALCONFIG.
------------------------
When I use no password, I get the following:
(localconfig file left unchanged). $db_user = 'bugs';
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Checking for DBD-mysql (v2.9003) ok: found v2.9004
Checking for MySQL (v4.1.2) ok: found v4.1.20

Creating database bugs...
The 'bugs' database could not be created. The error returned was:
Access denied for user ''@'localhost' to database 'bugs'.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
------------------------
When I use password I get:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Checking for DBD-mysql (v2.9003) ok: found v2.9004
There was an error connecting to MySQL:
Access denied for user 'bugs'@'localhost' (using passowrd:YES)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I tried to create 'bugs' database with no tables but it didn't help.

Operating system RHEL4.
All manipulations with MySQL made through Webmin
Bugzilla version 3.0.5


0
volteco
10/28/2008 4:44:22 PM
mozilla.support.bugzilla 10162 articles. 0 followers. Post Follow

4 Replies
1333 Views

Similar Articles

[PageSpeed] 39

Login to mysql as root user,

mysql -u root -p

mysql> flush privileges;

Try logging in from the mysql command line client, something like...
mysql -u bugs -h localhost -p

enter the password when prompted.

On Tue, Oct 28, 2008 at 10:14 PM, <volteco@gmail.com> wrote:

> I have the same problem as the person before me - earlier in the
> conference.
>
> Bugzilla script can not create database 'bugs'.
>
> I created two MySQL users: bugs and bugs@localhost and gave them full
> permissions.
> I edited file LOCALCONFIG.
> ------------------------
> When I use no password, I get the following:
> (localconfig file left unchanged). $db_user = 'bugs';
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Checking for DBD-mysql (v2.9003) ok: found v2.9004
> Checking for MySQL (v4.1.2) ok: found v4.1.20
>
> Creating database bugs...
> The 'bugs' database could not be created. The error returned was:
> Access denied for user ''@'localhost' to database 'bugs'.
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ------------------------
> When I use password I get:
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Checking for DBD-mysql (v2.9003) ok: found v2.9004
> There was an error connecting to MySQL:
> Access denied for user 'bugs'@'localhost' (using passowrd:YES)
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> I tried to create 'bugs' database with no tables but it didn't help.
>
> Operating system RHEL4.
> All manipulations with MySQL made through Webmin
> Bugzilla version 3.0.5
>
>
> _______________________________________________
> support-bugzilla mailing list
> support-bugzilla@lists.mozilla.org
> https://lists.mozilla.org/listinfo/support-bugzilla
> PLEASE put support-bugzilla@lists.mozilla.org in the To: field when you
> reply.
>



-- 
ShiB.
Stay away from credit cards.
Invest in yourself.
0
Shibashish
10/28/2008 6:33:29 PM
Thank you but I don't see how it can help to resolve the issue.
I did what you mentioned.
I can log in as bugs user with no problems.
0
Danila
10/28/2008 8:19:16 PM
On Tue, 28 Oct 2008 13:19:16 -0700 (PDT) Danila <volteco@gmail.com>
wrote:
> Thank you but I don't see how it can help to resolve the issue.
> I did what you mentioned.
> I can log in as bugs user with no problems.

	Paste the exact error message exactly as it's printed by
checksetup.pl. If you can, paste the entire output of checksetup.pl.

	-Max
-- 
http://www.everythingsolved.com/
Competent, Friendly Bugzilla and Perl Services. Everything Else, too.
0
Max
10/28/2008 10:02:57 PM
Finally I found the problem.
When I was creating MySQL user 'bugs',
I was leaving 'hosts' field by default - set to 'Any' (I am using
Webmin to work with MySQL)
When I changed it to 'localhost' in went through!
0
Danila
10/29/2008 1:25:52 PM
Reply:

Similar Artilces:

''''''''''''''''''''
Name: haznen Email: haznenatyahoodotcom Product: Gran Paradiso Alpha 8 Summary: '''''''''''''''''''' Comments: '''''''''''''''''''''''''''''''''''' Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9a1) Gecko/20061204 UGES/1.7.2.0 GranParadiso/3.0a1 From URL: http://www.mozilla.org/projects/granparadiso/ Note to readers: Hendrix gives...

'''''
Name: mario Email: ramar17atfastwebnetdotit Product: Gran Paradiso Alpha 2 Summary: ''''' Comments: K: Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9a2) Gecko/20070206 GranParadiso/3.0a2 ...

'do' won't 'do' if '/'
Greetings to All from Au, Have a NetWare Perl 5.8.4 and wanted to tweak File\Spec\NW.pm to try and standardise on '/' separators. If I run a test script (t/uni/lower.t) with an unmodified NW.pm, it calls t/uni/case.pl, that, in case.pl, (when the path separators are '\'), the $file is '..\lib\unicore\To\Lower.pl' and the following code portion works, with $simple getting a returned table: sub casetest { my ($base, $spec, $func) = @_; my $file = File::Spec->catfile(File::Spec->catdir(File::Spec->updir, "lib", &qu...

'''
Name: L Lachowsky Email: e2brutus_10atyahoodotcom Product: Firefox Summary: ''' Comments: why duddn this surprise me... I change default server from IE to Mozilla, and then i get error messages. well, shud I decide to not get on my computer with Mozilla..or shud I risk security breeches with IE....hmmm at least i can get on the internet with IE Browser Details: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5 From URL: http://hendrix.mozilla.org/ Note to readers: Hendrix gives no expectation of a response to this fee...

Cast from type ''''DBNull'''' to type ''''String'''' is not valid.
How do I avoid getting this error: Cast from type ''''DBNull'''' to type ''''String'''' is not valid. I am trying to get values from the database into a form for updating using a Datareader, SQL is set to allow nulls for certain fields as they are not required but the only way I can get the form to display is by adding a space in SQL. Is there another way around this? Check if it is equal to DBNull.Value first and if it is, don't do the cast.Stanley Tan theSpoke Blog Where in the code does it need to go? I am using the following and it's the profile that isn't always requi...

'b'..'a'
Hello. I'm using defferent 5.6.0's for Win32. I wonder wheter following behaviour is intentional or not: d:\>perl -e "print 'b'..'c'" bc d:\>perl -e "print 'b'..'a'" bcdefghijklmnopqrstuvwxyz I expected empty list in latter case, like in perl -e "print 'bb'..'a'" <!ENTITY Vadim REALLIFE "Vadim V.Konovalov, St.Petersburg, Russia"> &Vadim; On Wed, Sep 20, 2000 at 03:14:41PM +0400, Konovalov, Vadim wrote: > Hello. > > I'm using defferent 5.6.0'...

'IN' Clause or 'OR'
Hello, [1]: select * from TABLEA where COL1 IN('value1','value2''valu3'....) [2]:select * from TABLEA where COL1 = 'value1' OR COL1= 'value2' OR COL1='valu3'. TABLEA is a huge table and it has non-clustered index on COL1. Among the above 2 queries, which query will give me the better performance or fast response and WHY? What is the difference between 'IN' and 'OR' clauses as for as Sybase Optimization is concerned. Which is the better one to be used on huge tables. Thanks. Mac An IN list is treated ...

'or' or 'union'
Hello I was just wondering, in general what is better to use, an 'or' clause in a select or a 'union' to join two selects together. Do both statements create work tables? Many thanks Alex I think OR will be better than union. because suppose u have 3 tables and using OR u can join table a and table b and table c so each table will have only one read. but using union you will join table a and table b and in another query of union u will use table (a or b) and table c so ur one read is more in union . Ramdas Alex Cheung wrote: > Hello > >...

EXEC sp_msforeachtable 'sp_spaceused ''?'''
What does the following SQL code mean?  EXEC sp_msforeachtable 'sp_spaceused ''?'''Johan TheunissenMCPD, MCSE, MCTS BizTalk 2006==============================Please mark the most helpful reply/replies as "Answer". JohanNL:sp_msforeachtable This is the name of the SP that resides in the master database.  This SP executes one or more commands for a table. JohanNL:sp_spaceused This is the command that you want to run for each of the tables residing in your current database.  As you might have understood so far, that this is again a...

'To', 'CC', & 'BCC'
Name: Dick Tracy Email: philipdottracyatoptusnetdotcomdotau Product: Thunderbird Summary: 'To', 'CC', & 'BCC' Comments: I have just started using Thunderbird and while I find it quite excellent- I suggest having a button to add addressees to 'BCC' as well. Currently each 'BCC' addressee has to be selected manually. I send e-mail to quite a number of people at a time and I do not wish to readily spread others addresses easily. Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0....

'Value' should be between 'minimum' and 'maximum'.
I'm attempting to invoke with parameters:  Dim thing2 As New mydelsubPBStep(AddressOf pbStep) Me.Invoke(thing2, "setMax", dt.Rows.Count)      <---- this is where the error occurs   the delegate looks like this: Private Delegate Sub mydelsubPBStep(ByVal mode As String, ByVal value As Integer)   the function it's calling looks like this:Private Sub pbStep(ByVal mode As String, ByVal value As Integer) Select Case mode.ToLower Case "clear" ProgressBar1.Value = 0 Case "step" ProgressBar1.PerformStep() L...

The SELECT permission was denied on the object '', database '', schema 'dbo'.
 hay there...i'm developing a website using visual studio 2005, when i run it from VS it works fine and it can access the DB.but when i make an alias and run it directly from localhost ..i keep getting this message when i try to fill a DATASET ..Line 198: cmd.CommandText = "Select Line From Buses";Line 199: da.SelectCommand = cmd; Line 200: da.Fill(ds);can anyone help me ?thanx GLORY~Please mark as answer if this helps u~ Hi, we need to check the connection information, how are you connecting. Its obvious that different information/user is...

Bugzilla User 'nobody' and Profile Field 'Groupset'
One of my users is complaining that (he) is getting notified every time that a new bug is set up (when it is initially assigned to 'nobody'). When this happens, this particular user gets an email. Didn't note anything unusual about his settings via the web interface to Bugzilla, but when I looked at his profile record under MySQL I noticed he has a groupsetting of '9223372036854775807' which is very different from everyone else's. Does this have anything to do with it? Two questions: (1) How do I turn off notifying this user everytime something gets as...

Bugzilla: Make it possible to mark a single report as 'my bug' into 'my bugs'
Name: FJ Product: Other (please state) Summary: Bugzilla: Make it possible to mark a single report as 'my bug' into 'my bugs' Comments: Hello! I would like a button when viewing a bug to make it my bug. Now there is now way i've found to do this. And I wouldn't like to vote for it, just keep an eye on it. I wouldn't like to get emails about it tho. Maybe it's a good idea, maybe not. Likely not a high priority. Unlike Bugzilla as a whole! Whereas Bugzilla isn't as fun as many other dev tasks, it's very important. And thus making Bugz...

LINQ -- how to do where x in ('a', 'b','c')
How do I write a LINQ expression that does the following: select * from SomeTable where SomeColumn in ('a', 'b','c')  Jay There is no IN operator in LINQ (yet), but you can use Contains instead: http://www.devauthority.com/blogs/jwooley/archive/2007/08/06/69922.aspx Jos...

Web resources about - Installation Problem with Bugzilla - Access denied for user ''@'localhost' to database 'bugs' - mozilla.support.bugzilla

Resources last updated: 11/26/2015 2:07:56 PM