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 Quote Link to comment 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.... Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.