Alright hope you all can help with this , I've been messing with this MySQL server for about an hour now and I'm confused...first of all, it somehow forgot the root password and remembered a random one...so it took me a long time to change that back and btw, I didn't do anything to make it change. I fixed that restarting the server with --skip-grant-tables and then entering in a new password and then flush privileges. now, all users can access all databases and make changes. how can i limit which ones they can access...and btw this is a side problem - why, when I use GRANT ALL ON... can my users not create tables...I was under the impression that GRANT ALL meant..well...grant ALL...thanks for any help you can supply
Have you try using a GUI tool from MySQL, it make things a little easier to manage users rights within mysql down to table's level. http://www.mysql.com/products/tools/administrator/ If you really want to use the console to config all user rights, you should check out the default [mysql] database and do a show tables; all the user rights are stored there.