Hi List, I hate to bother the list with what should be a simple question but I've been unable to get this to work or find anything on mysql.com or google.
I need to grant : Create_tmp_table_priv on a particular database. As root (mysql user) I tried : grant Create_tmp_table_priv on mydatabase.* to [EMAIL PROTECTED]; but it doesn't work : ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Create_tmp_table_priv on mydatabase.* to [EMAIL PROTECTED]' Am I missing something really obvious here? This is on 4.0.18-standard. The server is an upgraded 3.23.x not a clean 4.0.x install. Possibility of something old causing this to break? Thanks in advance... __________________________________ Do you Yahoo!? Yahoo! Finance Tax Center - File online. File on time. http://taxes.yahoo.com/filing.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]