Unable to connect to website hosted on Azure

Question

Hi

I have a drupal/MySQL website hosted on Azure. I can connect to the website with no issues. However, when I try to log-in, I get an error. The ClearDB support centre thinks the user in the error message is different to the user created on the MySQL database and require change, but without the ability to connect, this can be verified and solved. Please help. The error is:

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1142 INSERT command denied to user 'b40c90effc5c0e'@'213.199.134.209' for table 'watchdog': INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => user [:db_insert_placeholder_2] => Session opened for %name. [:db_insert_placeholder_3] => a:1:{s:5:"%name";s:5:"admin";} [:db_insert_placeholder_4] => 5 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => http://ruddington-shotokan.co.uk/user [:db_insert_placeholder_7] => http://ruddington-shotokan.co.uk/user [:db_insert_placeholder_8] => 86.157.241.98 [:db_insert_placeholder_9] => 1408033458 ) in dblog_watchdog() (line 154 of D:\home\site\wwwroot\modules\dblog\dblog.module).