List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 13 2002 5:49pm
Subject:Re: How to create temporary table in 4.0?
View as plain text  
>I can't get CREATE TEMPORARY TABLE to work due to a privilege problem.

Run the mysql_fix_privilege_tables script.  There are new privileges
in 4.0.2, one of which applies to temporary tables.

>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;
>
>---------------------------------------------------------------------
>Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <mysql-thread116988@stripped>
>To unsubscribe, e-mail <mysql-unsubscribe-paul=snake.net@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Thread
How to create temporary table in 4.0?Philip Mak13 Aug
  • Re: How to create temporary table in 4.0?Paul DuBois13 Aug
  • Re: How to create temporary table in 4.0?Jocelyn Fournier13 Aug