Movable Type 4.23: INDEX command denied

[#1]

Hi all,
I'm trying to set up the latest version of Movable Type on CCGI, but apparently I don't have permission to use the INDEX command in MySQL. I'm not too au fait with the workings of MySQL, would having this command enabled be a security risk? If not, could we get it enabled? Or does anyone have a workaround at all?
For reference, the full list of commands MT needs is apparently:
grant
lock tables
drop
create temporary tables
update
create
alter
index
select
references
insert
delete

[#2]

I had an issue installing Movable Type too.  During the process, I got [tt]access denied for CREATE INDEX[/tt] errors.  I managed to create some of these indexes using phpMyAdmin and the MT error messages, but this was taking too long so I altered the source code instead.
I modified the file mt/lib/MT/ObjectDriver/DDL.pm on line 300 where I changed the following:

push @stmts, "CREATE INDEX ${table_name}_$name ON $table_name (${field_prefix}_$name)";

to this:

push @stmts, "ALTER TABLE $table_name ADD INDEX ${table_name}_$name (${field_prefix}_$name)";

and then began the installation afresh.  It worked like a charm.