[vox-tech] mysql: printing all users and databases

[Peter Jay Salzman]

thanks tim,

i'll give it a try.  i have to say, i'm a little disheartened with
mysql.  i just want it to "work" and be secure.

from reading the docs, it _appears_ (although it doesn't say explicitly)
that not only does each username have a password, each user has a
password for each hostname.  so 'root'@'localhost' may have a different
password than 'root'@'someotherhost'.  that's just too bizarre for my
mind.

it also looks like a database name of "mysql" may refer to the
collection of all databases, but i haven't verified that yet.

plus having anonymous users... really, anonymous.  as in, so anonymous
that they don't even have a username, is a really strange concept.  even
anonymous ftp users have a username of "anonymous".

i wanted to set up a slashcode system, but i may just put that off till
i have more time to sit down and read mysql docs.  the more i learn
about mysql, the more i'm starting to realize there's no possible
quickstart...   :(

i'll give it a few more hours before i put it off as a "major
undertaking" to be attempted when i have less on my plate than i do
now.

i'll try your suggestions.  thanks!

pete


On Mon 15 Mar 04,  9:01 AM, Tim Riley <timriley@timriley.net> said:
> On Mon, 2004-03-15 at 04:58, Peter Jay Salzman wrote:
> > i see how to create new mysql users and new mysql databases, but how
> > does one print all mysql users on a given host?
> Did you try "select * from user"? It's just a guess because the book
> says the table exists, but it doesn't appear in my instance. (Maybe
> because I've never issued the "grant" command.)
> 
> >   is there something like
> > an /etc/shadoow for mysql?
> > 
> > how does one print the name of all mysql databases on a given host?
> "show databases"
> 
> > 
> > pete
> > _______________________________________________
> > vox-tech mailing list
> > vox-tech@lists.lugod.org
> > http://lists.lugod.org/mailman/listinfo/vox-tech
> 
> _______________________________________________
> vox-tech mailing list
> vox-tech@lists.lugod.org
> http://lists.lugod.org/mailman/listinfo/vox-tech

-- 
Make everything as simple as possible, but no simpler.  -- Albert Einstein
GPG Instructions: http://www.dirac.org/linux/gpg
GPG Fingerprint: B9F1 6CF3 47C4 7CD8 D33E 70A9 A3B9 1945 67EA 951D