I came across this structure the other day and was intruiged by it. I've never seen it work quite this way.
mysql> show grants; +----------------------------------------------------------------------------+ | Grants for username@% | +----------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'username'@'%' IDENTIFIED BY PASSWORD '3fe3e225241cbfe4' | | GRANT ALL PRIVILEGES ON `timehrs`.* TO 'username'@'%' | | GRANT ALL PRIVILEGES ON `sweepy`.* TO 'username'@'%' | | GRANT ALL PRIVILEGES ON `files`.* TO 'username'@'%' | | GRANT ALL PRIVILEGES ON `userdb2`.* TO 'username'@'%' | | GRANT ALL PRIVILEGES ON `wifi`.* TO 'username'@'%' | | GRANT ALL PRIVILEGES ON `userdb`.* TO 'username'@'%' | +----------------------------------------------------------------------------+ 7 rows in set (0.01 sec) I've always just given each user/password combination their own privileges and left it at that. Is it common practice to use just one password on the usage and then grant extra privileges to each database? Thanks, Adrian
_______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
