Another MySQL question

[Riga, Anthony]

TO set rights for user you want to do :
GRANT USAGE ON *.* to dbuser at localhost IDENTIFIED BY 'password';
you have to be connected to the database as root in order to run the commands.
Good Luck! 


-----Original Message-----
From:	One Untraceable [mailto:one_untraceable at yahoo.com]
Sent:	Tue 10/7/2003 4:46 PM
To:	nflug at nflug.org
Cc:	
Subject:	Re: Another MySQL question
Bob,
 That just gives me the mysqladmin help page..(Like
doing mysqladmin --help) 


thanks


--- Robert Meyer <meyer_rm at yahoo.com> wrote:
> How about mysqladmin -uroot -ppassword
> 
> Cheers!
> 
> Bob
> --- One Untraceable <one_untraceable at yahoo.com>
> wrote:
> > I have just installed MySQL and I am attempting to
> set
> > the root password and here is what I get. When I
> try
> > to run "mysqladmin" I keep getting this error:
> > [root at www bin]# mysqladmin -u root password
> > 'new-password'
> > mysqladmin: connect to server at 'localhost'
> failed
> > error: 'Access denied for user: 'root at localhost'
> > (Using password: NO)'
> > [root at www bin]#
> > 
> > 
> > Anyone have any ideas?
> > 
> > Thanks
> > 
> > __________________________________
> > Do you Yahoo!?
> > The New Yahoo! Shopping - with improved product
> search
> > http://shopping.yahoo.com
> 
> 
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Shopping - with improved product
> search
> http://shopping.yahoo.com


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com



-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 2995 bytes
Desc: not available
Url : http://www.nflug.org/pipermail/nflug/attachments/20031007/7fa2991f/attachment-0001.bin