I can't get CREATE TEMPORARY TABLE to work due to a privilege problem.
Does anyone know what I'm doing wrong?
mysql> update user set create_tmp_table_priv='Y';
Query OK, 0 rows affected (0.00 sec)
Rows matched: 2 Changed: 0 Warnings: 0
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
[root@priam root]# su - seasft
[seasft@priam seasft]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 48909 to server version: 4.0.2-alpha-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create temporary table x (x int);
ERROR 1142: create command denied to user: 'seasft@localhost' for table 'x'
I've also tried:
grant create temporary tables on * to seasft@localhost;
grant create temporary tables on *.* to seasft@localhost;