Another MySQL question

[Riga, Anthony]

If you are logged on to mysql and do SHOW DATABASES; then you will see the database MYSQL. Then do USE MYSQL; then SHOW TABLES. Then just use a SELECT statment to select what tables you want. The passwords and users are stored in the USER table. Pretty sure thats how you get to view the information. But I think the passwords are encrypted. Not sure if im helping you.. though. 
 


-----Original Message-----
From:	One Untraceable [mailto:one_untraceable at yahoo.com]
Sent:	Tue 10/7/2003 7:50 PM
To:	nflug at nflug.org
Cc:	
Subject:	Re: Another MySQL question
Can someone tell me where MySQL stores the Admin and
user passwords for it's databases?

Thanks




--- One Untraceable <one_untraceable at yahoo.com> wrote:
> 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


__________________________________
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: 3231 bytes
Desc: not available
Url : http://www.nflug.org/pipermail/nflug/attachments/20031007/d022f3bd/attachment-0001.bin