Getting 1044 error as my host doesn't have LOCK TABLES enabled

Hi,

I thought I would give Drupal a go after it was recommended to me and started to install it last night. Managed to run the schema to create all the tables in my mySQL database but when I tried to grant LOCK TABLES for my database user it failed. So the statement I ran was....

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX,
ALTER, CREATE TEMPORARY TABLES, LOCK TABLES
ON fourmarks2.*
TO 'fourmarks2'@'mysql8.streamline.net' IDENTIFIED BY 'xxxxxxxx'

....and the error I received was....

#1044 - Access denied for user 'fourmarks2'@'%' to database 'fourmarks2'

I have seen several other threads with this error but there is no definitive resolution. If my host doesn't have LOCK TABLES enables then is there a workaround?

I'm using Drupal 4.7.4.

Many thanks in advance,

Dicky