[SOLVED] SQL Collation Error after upload to 1&1 server

I've a working Contao 2.9.RC1 installation running on my Windows PC. I'm having trouble getting running after uploading it to my 1&1 server. It feels like a brick wall but I hope it's not as I've spent hours building my Contao app

The error after unloading this working system and on running install is:

Fatal error: Uncaught exception Exception with message Query error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATION LIKE 'UTF8%'' at line 1 (SHOW COLLATION LIKE 'UTF8%') thrown in /homepages/1/xxxxxxxxxxx/htdocs

Running 1&1 phpMyAdmin I find that the following SQL command:
SHOW COLLATION LIKE 'UTF8%'
gives an error message:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATION LIKE 'UTF8%'' at line 1

EDIT: SOLVED:
MySQL manual says SHOW COLLATION is available as of MySQL 4.1.0.
So looks like the problem is because I running on 4.0.27
So I need to upgrade my database to 5

Done that and it runs :)