MyBB Community Forums

Full Version: SELECT command denied by database?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hey guys,

connecting externally to the database creates some issues for me as it rejects my select commands. Is there a database setting which prevents it or is the problem elsewhere? I've once successfully connected via localhosted website but from the same webserver it's kinda creating trouble.

Quote:An error occured: SELECT command denied to user...

Regards
Host problem. Contact them. Make sure your DB info is correct in inc/config.php

You must make sure that the user for mysql your using has proper permissions.
DB info is correct as well as the perms for the user.

Thanks for your help.
So you've fixed it?
The issue is that your mysql db user cannot use select. Either contact your host if you can't change user permissions of mysql users or give the user SELECT permissions in mysql db via your host control panel.
I fixed it, the issue was me being a bit retarded. I forgot the table prefix mybb_ when selecting the table - unfortunately (actually its a good thing Wink) the mysql error wouldn't tell me to prevent people with no access to be aware of the database structure.