Grant privileges issues

[DeliveranceXXV]

Hi,

I am having issues with granting privileges to users on PHPMYADMIN.
I am looking to grant only certain privileges to a user and I keep getting errors everytime.

GRANT SELECT ON xxx . * TO 'xxx'@'mail.irishwindowshosting.com' IDENTIFIED BY 'xxx'

Which results in the error: #1044 - Access denied for user 'xxx'@'%' to database 'xxx'

Even if I...

SHOW GRANTS FOR 'xxx'@'mail.irishwindowshosting.com'

I get the error:
#1044 - Access denied for user 'xxx'@'%' to database 'xxx'

I am logged into PHPMYADMIN with the user I created with HELM's database create user function.

Any help would be greatly appreciated

[blacknight]

If you're having issues on that hosting platform you should move to our new one.

You'll have access to newer versions of asp, php etc.,