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

[Tim Riley]

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