you give the root user all privileges (see GRANT command) (but this should be set by default, anyway) and no (global) privileges (that is, 'usage') for other users. then you give the users only contents/structure related rights on their databases.
did you try phpmyadmin for this yet? it's a bit tricky, but it's very close to mysql's view of things, so you can learn easily by looking at the mysql commands generated. -- Yves Goergen [EMAIL PROTECTED] Please don't CC me (causes double mails) -----Ursprüngliche Nachricht----- Von: "System Administrator a.k.a. The Root of the Problem" <[EMAIL PROTECTED]> An: <[EMAIL PROTECTED]> Gesendet: Montag, 25. August 2003 19:12 Betreff: Restricting user access to databases > Just wondering, how do I limit a user to one database but > let the administrator have universal access? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]