Hello all: I have gone through the documentation, and also the archives, and still can't grasp why things happen with privileges.
Here is what I am trying to understand and accomplish. For my own benefit I'm trying ot understand the user and db tables of mysql. If I setup a user with no privileges, but in the db table they have privileges, that user can still select, insert, etc even when it is set to no in the user table. A couple questions I have: What are the differences between the user/db table? Also for the best security what shoudl I set the privileges to for everyone. There are multiple db's on the server, and only one user per db, and they only need the basic privilges, i.e. create tables, select, insert, etc. Your help is greatly appreciated. Mike Walth CinoFusion -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]