Problems populating DB with tables

[moonie]

Hello everyone!

I ran into a strange problem today installing 1.6.1. on a hosting where I've already successfully installed 1.5.4 and 1.4.1 some time ago. The problem is that the installer somehow doesn't seem to be able to populate the DB with tables during Step 5.

I entered all the info I got from the hoster (localhost, db, username, pass <-- they work as I can connect to phpmyadmin with the same data), but then it jumps to the actual table-creating page, where every table reads ... [failed] behind its name. There is no more info given on that page, neither a button to retry or some explanation of what failed.

Creating additional_users table... [failed]
Creating admin_bookmarks table... [failed]
Creating index in admin_bookmarks table... [failed]
.. and so on

I have tried the "grant all privileges on db382.* to db382@localhost identified by 'pass';" with db382 being the dbname and username, and 'pass' the password the hoster gave me, but I get a "#1044 - Access denied for user: 'db382@%' to database 'db382'" from phpmyadmin.

Can somebody point me in the right direction as to what could be the cause of the failed table creation? I am totally lost here, and the hoster doesn't seem to be able to help me either.

Edit:
- Apache 1.3.33
- PHP 4.3.10-22
- MySQL 4.0.24

[Dr.CSS]

When you created the DB did you give it a prefix or was it all just empty tables?...

Did you do a different prefix in step 5 then what was suggested, cms_ ?...

[moonie]

The table prefix was left at "cms_". Not a single table was created in that case, the DB is still empty after step 5.

Writing a dummy php-File that creates a test-table on the same db with the same user did work though, so it's not a permission problem it seems, that user is clearly allowed to write into the DB. I'll do a local install of 1.6 on my computer and put that DB up manually next, this should hopefully do the trick

[moonie]

Manually installing the tables from 1.6.1 on that db didn't work either, I was greeted with a

#1193 - Unknown system variable 'SQL_MODE' (it was installed on v. 5.1.30 and then imported to 4.0.24, not a good idea I guess)

I installed 1.5.4 on that hosting now, and it worked fine. I am now hesitant to upgrade to 1.6.2 though, as I fear it will break again 

[Dr.CSS]

That's what test sites are good for, like in a sub folder mysite.com/subfolder/...