Drupal search requires the "CREATE TEMPORARY TABLES" MySQL privilege

Wanted to fix the site search today and found the problem was database permissions. To fix I just granted the necessary permissions. Of course, I could only do that because I have access to the root MySQL account. Other Drupal sites on shared web hosting accounts might have to come up with other solutions. I’ve listed a few of these below.

hacking the core search module

• Drupal Search without temporaty tables- Solution for godaddy hostings
• mysql and the CREATE TEMPORARY TABLE privilege

use a different search module

• SQL Search (Trip Search)

Use a VPS host instead of shared hosting

• Drupal on a Budget

Obtain sufficient database rights

Here is the MySQL command necessary:

• GRANT CREATE TEMPORARY TABLES ON mydatabase.* TO ‘myuser’@’%’;

And to verify:

• SHOW GRANTS FOR ‘myuser’;