"Unable to create temporary tables." preventing install

[Elfreda]

Hello,
I have created a sandbox installation so that I could see if CiviCRM would be suitable for our organization.
I have installed the latest xampp on ubuntu 8.04 installed on VirtualBox and then got drupal 6.4 working. I have followed the steps for installing CiviCRM 2.1.beta6. I resolved a couple of issues (changed InnoDB settings and memory allocation) The last problem is that the installer says that the user specified does not have permission to create temporary tables. I have checked this setting in phpadmin and the user has all privileges for everything.
I'm not sure what else to check.
Thanks for any help/suggestions,
Elfreda

[alfred_nutile]

Phpmyadmin has menus to choose which database the users permissions are related to.
Did you look at the settings for the right user?
And is this the user the script is trying to make the database with?
Can you try it at the command line as well?
mysql -u root -ppassword

then
create database;
or create other type of table etc?

[Elfreda]

Thanks for the answer.
I have tried using both the user I created (has 'all privileges' showing in phpmyadmin) and 'root' to run the install script. I can see the checkbox ticked for 'create temporary tables' for my user. I had also granted my user rights to the drupal database explicitly.
I logged in as my user and as root at the command line and created databases and temporary tables without errors.
I'm not sure what to try next except for a re-install.

[Elfreda]

Yay! I got it installed. I had to manually create the civicrm database first.

The instructions state

The installer will create a new database for CiviCRM automatically if you enter a database name that doesn't already exist on your database server AND the database user you enter has permission to create databases.

Both the conditions were satisfied so this fix didn't occur to me right away. So, just a little glitch.

It looks interesting--I'm really looking forward to playing with this!

[sypl]

Yay! I got it installed. I had to manually create the civicrm database first.

Do you mean you created the database manually via a command line? Or is there another way to grant the 'CREATE TEMPORARY TABLE' permission?

[Elfreda]

I tried creating databases and temporary tables using the 'root' login and the user id that I had created from the mysql command line as alfred_nutile had suggested to try to track down the problem. Then I decided to create the empty civicrm database before trying to run the install script again. I created the database using phpmyadmin and double-checked that my user had full permissions. I think the glitch might have been that the script was testing if the user had the permission to create temporary tables on a non-existant table.

[Donald Lobo]

i assume u mean a non-existent database

I just checked the code and seems like we dont do the right thing if the db does not exist (which matches the behavior u get). Can you please file an issue for this. We'll fix this in the 2.2 installer.

thanx

lobo

[Elfreda]

Yes, non-existent database.
Thanks for the reply--I wasn't sure about filing an issue or not.
elfreda

[BrightBold]

Thanks for this thread! I was having trouble eliminating all the barriers to installation (I'm new to both Linux and server admin so dealing with all the permissions problems isn't yet second nature), but creating the database manually before installation has solved the problem.