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]