When from 3 to 4, ran the update_privs_table thngy...
All my users used to say Global Privileges "USAGE" now they are all "CREATE TEMPORARY TABLES, LOCK TABLES" I am not sure this is good or bad, nor am I sure how these settings got in there.
They got there when you updated the grant tables.
What are your suggestions? I don't think I want any user able to LOCK tables, these are global so I assume all databases are able to be locked by all users.
Whats the best way to udpate all these back to the "USAGE" they were at before. --
UPDATE user SET Create_tmp_table_priv = 'N', Lock_tables_priv = 'N', ... ; FLUSH PRIVILEGES;
You might want to add "WHERE User != 'root'" to that, if you don't want root accounts to have those privileges disabled.
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
