-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, all --
After experimenting with the input from Benjamin I can GRANT all I want, but still only on a single database (though if I know the name I can do so in advance of its creation). This still seems a little troublesome. I expect that it's in the "use and implementation of mysql" department rather than "actual mysql workings" department, though. I'd like for users, like my junk user, to have a "kinda"-root account which can manage all of, but only, the junk_*.* databases, whether or not they yet exist, and create other junk_subuser accounts for whatever limited granting is necessary. Am I living in a dream world? If so, how do other service providers do this? I'm certain you don't give each customer a db root account :-) but do your customers have to come to you for a new database or a new user? TIA & HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+eE1xGb7uCXufRwARAlX4AKCqk9wodTx3+i1Dz06Mpgq0nooo3ACgrR9G MT2Dp08aUeOrqR9pc1XSVF4= =/3bf -----END PGP SIGNATURE----- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php