[IMC-Dissent-admin] DADA hack / Upgrading to .99.2

[warren at riseup.net]

The Atlanta IMC crew is trying to upgrade Dada from .98.1 to .99.2.  when
we access the upgrade.php page, we run into the following error message
regarding "drop priviledges"  [see below].   We have tried the step by
step instructions for uncommenting lines in 98_mysql_imc_update.sql
to solve the problem, but it still doesn't work.  Can anyone advise us as
to how to fix this?

Thanks,
Sincerely,
Warren and Mahsa,
IMC-Atlanta


Trying to execute GRANT DROP ON `dadaatlantaimc`.* TO `atlanta`@`localhost`;
Access denied for user: 'atlanta at localhost' to database 'dadaatlantaimc'

The dadaIMC MySQL account needs to have "drop table" permissions in order
to modify the database. Checking now...
Examining GRANT USAGE ON *.* TO 'atlanta'@'localhost' IDENTIFIED BY
PASSWORD '0754f96c6cdec22e'
Examining GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, ALTER ON
`dadaatlantaimc`.* TO 'atlanta'@'localhost'
Examining GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, ALTER ON
`dadatlantaaimc`.* TO 'atlanta'@'localhost'

You do not appear to have permission to drop tables. This is a bad thing,
but we can try to fix it.

If you have the MySQL root user name and password (or any user with
privileges to update the tables in the 'mysql' database, enter them below.
f you have the MySQL root user name and password (or any user with
privileges to update the tables in the 'mysql' database, enter them below.
MySQL root access username:   Password:

If you do not have access to a MySQL username capable of changing these
permissions:

   1. Open the /docs/upgrade_98/98_mysql_dt_update.sql file
   2. Find the DROP TABLE and CREATE TABLE commands for the "modules" table
   3. Comment out or delete those lines
   4. Remove the "#" comment markers from the commands immediately
following that section
   5. Save the file in its original location
   6. Reload this page, or start the upgrade process again.

Existing "safeguard" DROP TABLE commands exist for other tables, and will
generate harmless errors when you install dadaIMC. This should only occur
with tables that you do not have yet anyway, and so the errors can be
disregarded.