Error after error after error…?

So far the 5 min. install of wordpress has taken 3 days…and counting.

I’m trying to install wordpress in a subdirectory in the root of my website. My host, EDTHosting claims that the server is compatible with wp.

Their control panel requires me to create a user and a database in one step, but it returned an error that the host had to be notified. I could not log into phpMyAdmin.

They created a new user, password, and database. I logged into phpMyAdmin but there were no privilages as described in the wp documentation. I tried to install wp with IE8 but received a 500 server error. The host said they had to add privilages to my user, which they then did.

I then installed wp but with errors…
WordPress database error: [Specified key was too long; max key length is 767 bytes]CREATE TABLE wp_terms ( term_id bigint(20) unsigned NOT NULL auto_increment, namevarchar(200) NOT NULL default ”, slug varchar(200) NOT NULL default ”, term_groupbigint(10) NOT NULL default 0, PRIMARY KEY (term_id), UNIQUE KEY slug (slug), KEY name(name) ) DEFAULT CHARACTER SET utf8

WordPress database error: [Table ‘xxxxxx_wp1.wp_terms’ doesn’t exist]INSERT INTO wp_terms (term_id,name,slug,term_group) VALUES(‘1′,’Uncategorized’,’uncategorized’,’0′

WordPress database error: [Table ‘xxxxxx_wp1.wp_terms’ doesn’t exist]INSERT INTO wp_terms (term_id,name,slug,term_group) VALUES(‘2′,’Blogroll’,’blogroll’,’0′)

(I replaced my table names above with xxxxxx)

…something doesn’t seem right. Is it supposed to be this hard?