[ale] [Slightly OT] Simple(?) MySQL question

Richard Atcheson ratcheson at earthlink.net
Wed Jun 15 20:38:36 EDT 2005


On Monday 13 June 2005 08:03 am, Michael B. Trausch wrote:
> I know it's possible; the question really just is, how? ?And why doesn't
> simple searches from Google yield me a result? ?Perhaps I'm just too
> stupid to figure out the keywords... I'm still working on that, though.

Mike, have you gotten an answer to your question yet?

I have a book from O'Reilly titled Managing and Using MYSQL which has some 
good info like you're seeking.  Its chapter 6, entitled Security is the one 
you need.  Covers about 20 or so pages.  It has titles in it like Database 
Security and System Security which explains the system of managing users and 
privileges.  You might find an electronic form of it on the O'Reilly website.  

Using admin commands such as mysql and mysqladmin you set up all users, 
including root, for Mysql.  Using privilege management you set up a bunch of 
internal tables using GRANT and REVOKE to permit users to use mysql.  Other 
keywords are mysql host tables.  

I deplore the use of RTFM but in this case the chapters are to long for me to 
type so from here you're on your own.

HTH,
Richard



More information about the Ale mailing list