Hi everyone, Please pardon my extreme case of the NEWBs on this but I need some help please. Ok I just purchased a book to hopefully clear things up for me, but to no avail. So this is my dilemma: I want to know about MySQL administration, specifically the user management portion of the admining. I want to be able to allow users to create whatever DBs they need. One DB for my Multi-media collection, one for an address book, one DB for links for a web site. Whatever the case may be! But it seems like I can't give a user the option to create and/or delete any DBs that only user X made. So I the admin would have to create each DB and assign appropriate privileges to appropriate users?
So to sum up my situation into a question: Is it possible for me to give a user the ability to create and/or delete only their DBs? Or do I have to make the DB for them and then Grant appropriate privileges for that user to that DB? Thanx in advance for the help __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- 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