Jim Chivas wrote: > Greetings: > > I saw a reply you sent to a mysql user about setting up new users to > mysql. I am hoping you can clarify some questions for me. > > I referenced the url you gave out at the mysql.com/documentation/..... It > was suppose to show how to setup users but does not give actual examples. > > Can you offer me the correct syntax to: > > 1. create a new user. > > 2 allow this new user the capability to create and and/change to a > database they create. > > 3. How to remove any databases a particular user has created. > > 4. How to remove a user from using mysql (delete them off the mysql > system) > > I am asking these questions from a teaching point of view. My faculty want > to teach mysql so either I or they must be able to create their student > users and remove them after the class has completed. > > Is it possible to allow each instructor to create and delete users and > their databases or must the 'root' user do it? > > If so how would I create an mysql instructor id to perform this creation > and deletion functions?
Hi Jim, Please CC the mysql list (address above) on questions like this so that the question/answer is archived and the rest of the world can gain from your problem and the potential solutions. Check out the following URL: http://www.mysql.com/doc/U/s/User_Account_Management.html It contains specific examples on creating users etc. (4.3.5 Adding new users to MySQL) If you still have questions dont hesitate to ask. --------------------------------------------------------------------- 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
