I recently installed Drupal 5.1 and it seems to be working fine on Dreamhost (although it hasn't been put to any real stress so far). However, Drupal says that it needs the following MySQL privileges:
SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
and goes on to say:
"Note: Unless your database user has all of the privileges listed above, you will not be able to run Drupal."
Dreamhost tech support told me that due to the nature of their shared accounts, they do not support CREATE TEMPORARY TABLES and LOCK TABLES, i.e. SQL users by default do not have them and there is no way to grant them.
I see that several people on the forums say that they've been running Drupal, including v 5.1, without any problems. Has anyone had any problems, apart from the mentioned mailhandler module problems? Does anyone have any idea as to the consequences of not having those 2 privileges? A little bit of decreased performance or slight data integrity risk would be acceptable, but I'd particularly like to know if people are experiencing any crashing or major corruption.