-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, all --
I am having a bit of trouble with GRANT and users and database access. I would like to do two things: - - Given a system user 'junk' I would like to create a "master" user 'junk' that can have all permissions (including grant?) on all 'junk_*' databases so that he can create and manage his own databases - - Given a "master" user 'junk' I would like for that user to be able to create other users 'junkNN' or or 'junk-*' or whatever so that my good friend junk is not always acting as "root". I have tried mysql> grant all privileges on junk_* to [EMAIL PROTECTED] identified by 'junk'; ERROR 1064: You have an error in your SQL syntax near '* to [EMAIL PROTECTED] identified by 'junk'' at line 1 mysql> grant all privileges on junk_.* to [EMAIL PROTECTED] identified by 'junk'; Query OK, 0 rows affected (0.24 sec) and so I guess the way to specify database matching is with pure regexp notation of '.*' for 'any character any number of times', and my tables now look like mysql> select * from mysql.db where user = 'junk' ; | localhost | junk_ | junk | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | mysql> select * from mysql.user where user = 'junk' ; | localhost | junk | 372b3ff6545565e4 | N | N | N | N | N | N | N | N | N | N | N | N | N | N | and I can even log in bash-2.05a$ mysql -ujunk -pjunk Welcome to the MySQL monitor. Commands end with ; or \g. but I can't create a database mysql> create database junk_testing ; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'junk_testing' OK, I figure, I'll create the DB as root and then get to it as junk, and work around the problem later. But that doesn't work, either! bash-2.05a$ mysql -u droot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. mysql> create database junk_test ; Query OK, 1 row affected (0.30 sec) mysql> quit; Bye bash-2.05a$ mysql -ujunk -pjunk Welcome to the MySQL monitor. Commands end with ; or \g. mysql> use junk_test ; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'junk_test' Maybe I have to re-grant, too. Grrr... bash-2.05a$ mysql -u droot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. mysql> grant all privileges on junk_.* to junk ; Query OK, 0 rows affected (0.20 sec) mysql> quit ; Bye bash-2.05a$ mysql -ujunk -pjunk Welcome to the MySQL monitor. Commands end with ; or \g. mysql> use junk_test ; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'junk_test' mysql> OK, now I'm just mad :-) Let's try granting to this specific database just to get things going. bash-2.05a$ mysql -u droot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. mysql> grant all privileges on junk_test to junk ; ERROR 1046: No Database Selected mysql> use mysql ; Database changed mysql> grant all privileges on junk_test to junk ; Query OK, 0 rows affected (0.02 sec) mysql> quit Bye bash-2.05a$ mysql -ujunk -pjunk Welcome to the MySQL monitor. Commands end with ; or \g. mysql> use junk_test ; ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'junk_test' mysql> Not only am I a little confused about having had to use a database before I could grant privs, but it didn't work anyway! I give up. Haaaalp! :-) 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+bQdGGb7uCXufRwARArW+AKDZJ0t9ijYjx3MPK7vtZPjsVPcy3gCfZPlN voajSct6Bo9nYHBjh/Yip2o= =U/3l -----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