rtpmatt Posted August 21, 2007 Share Posted August 21, 2007 someone gave me the tremendous mysql line: GRANT ALL ON friends_db.* TO my_friend IDENTIFIED BY 'a password'; a while back. I am wondering if there is an easy way to have this run every time i create a new user on my server? So that each time i create a user they get their own (and only their own) DB. Thanks -matt Link to comment https://forums.phpfreaks.com/topic/65911-new-user-db-access/ Share on other sites More sharing options...
fenway Posted August 21, 2007 Share Posted August 21, 2007 This type of question always makes me wonder why people insist of making new users all the time.... Link to comment https://forums.phpfreaks.com/topic/65911-new-user-db-access/#findComment-330073 Share on other sites More sharing options...
rtpmatt Posted August 22, 2007 Author Share Posted August 22, 2007 I suppose i deserve that, i really don't do it much...and i suppose i should just do it by hand. Really though, every once in a while i have to add someone new, and i would just like to be able to say they can use a DB. That being said, learning how to do such a thing in linux wont hurt me, I do enjoy learning it the bit by bit, wish i knew it like i did win. Link to comment https://forums.phpfreaks.com/topic/65911-new-user-db-access/#findComment-330631 Share on other sites More sharing options...
fenway Posted August 22, 2007 Share Posted August 22, 2007 Maybe there's a crazy trigger way, but I wouldn't trust it for anything grant-related anyway. Link to comment https://forums.phpfreaks.com/topic/65911-new-user-db-access/#findComment-331343 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.