l i n u x - u s e r s - g r o u p - o f - d a v i s
Next Meeting:
July 7: Social gathering
Next Installfest:
Latest News:
Jun. 14: June LUGOD meeting cancelled
Page last updated:
2004 Mar 16 01:29

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
Re: [vox-tech] mysql: printing all users and databases
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

On Mon, Mar 15, 2004 at 04:58:45AM -0800, 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?  is there something like
> an /etc/shadoow for mysql?

No.  MySQL keeps all its password and user information in a table in the
mysql database.  If you want to see the table structure, log into
mysql(mysql -p) and run: 

use mysql;
desc user; 

If you want to see a list of users and all associated hosts: 

select user, host from user; 

If you're worried about password security, I wouldn't be.  First off
IIRC mysql uses a secure hash for its passwords.  Secondly, if you keep
permissions on the mysql database locked down, no one can query against
it.  Thirdly, you should never use the same password for the db user as
you use for your system user.  

> how does one print the name of all mysql databases on a given host?

mysql -p mysql and either: 

select db, host from db; 


show databases; 

vox-tech mailing list

LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
Sunset Systems
Who graciously hosts our website & mailing lists!