1142: SELECT command denied to user

[jfisher446]

I'm getting this error whenever trying to access the DB:

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

SELECT log_type,log_action,log_user,log_namespace,log_title,log_params,log_comment,log_id,log_deleted,log_timestamp,user_name,user_editcount,ts_tags FROM `logging` FORCE INDEX (page_time,user_time) INNER JOIN `wiki_shared`.`user` ON ((user_id=log_user)) LEFT JOIN `tag_summary` ON ((ts_log_id=log_id)) WHERE (log_type != 'suppress') AND log_type = 'delete' AND log_namespace = '1' AND log_title = 'Main_Page' AND (log_deleted & 1 = 0) AND (user_id = log_user) ORDER BY log_timestamp DESC LIMIT 51​

from within function "IndexPager::reallyDoQuery (LogPager)". MySQL returned error "1142: SELECT command denied to user 'jfisher_user'@'lotus.x10hosting.com' for table 'user' (mysql-lotus.x10hosting.com)".

I have tried to create AND grant full permissions to 2 separate users and still the same error (just with the user info changed in them). Not too sure what's going on, as it all seems right. Any help will be much appreciated.
These are the parameters I'm using (from /public_html/wiki/Localsettings.php)

## Database settings
$wgDBtype           = "mysql";
$wgDBserver         = "mysql-lotus.x10hosting.com";
$wgDBname           = "jfisher_mydb";
$wgDBuser           = "jfisher_user";
$wgDBpassword       = "the_password";

 

[ah-blabla]

Try use "localhost" as the database server. All rerouting to the correct MySQL server is done internally (i.e. hidden to the user), so for your purposes you just need to use localhost.

 

[galaxyAbstractor]

Also, make sure you assigned all privilegies to the database user when you created it in cPanel.

 

[jfisher446]

localhost still causes it to fail.
All permissions are granted. I can also go into phpmyadmin and access, select, insert, and update with the same user, on the table 'user'.

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
SELECT log_type,log_action,log_user,log_namespace,log_title,log_params,log_comment,log_id,log_deleted,log_timestamp,user_name,user_editcount,ts_tags FROM `logging` FORCE INDEX (page_time,user_time) INNER JOIN `wiki_shared`.`user` ON ((user_id=log_user)) LEFT JOIN `tag_summary` ON ((ts_log_id=log_id)) WHERE (log_type != 'suppress') AND log_type = 'delete' AND log_namespace = '1' AND log_title = 'Main_Page' AND (log_deleted & 1 = 0) AND (user_id = log_user) ORDER BY log_timestamp DESC LIMIT 51
from within function "IndexPager::reallyDoQuery (LogPager)". MySQL returned error "1142: SELECT command denied to user 'jfisher_user'@'lotus.x10hosting.com' for table 'user' (localhost)".

Edit:
So...noone can help me with this? Fail.

How about some support since it seems that everything is correct.