InMotion Hosting Support Center

mysql database user permissions - access by table

Category: Databases

2012-10-11 2:29 am EST

Hits: 2,211
I can't seem to find any way to adjust mysql user permissions by table, only by database.

Normally I would perform such a task by doing "grant select on mydb.tablename to dbuser identified by 'password'" but since I am on a shared server, I don't have mysqladmin privileges to create users and can only do so through the cpanel, which doesn't have this option.

Is there any work around to limit mySQL users by table on a shared inmotion server?

This seems like basic functionality, but then again I've never worked on shared servers before and have always had full admin access. Is this common practice for shared servers to limit this? Is my only option to be more cautious with my php coding?

Also limiting queries/hour, number of connections would be useful

EDIT: I just found this

I can't believe this isn't available..

You must login before you can ask a follow up question.

You must login before you can submit an answer.



5,889 Points
2012-10-11 8:49 am EST
Thank you for your question sdegele!

Sorry the MySQL user privileges are not changeable per table basis on our shared servers. Unfortunately, the shared servers are locked down in regards to these functions to prevent security issues with the server and there is no work around.

Best regards,
James R.

You must login before you can post a comment about this answer.

Like this Question?

Support Center Login

Our Login page has moved, Click the button below to be taken to the login page.

Social Media Login

Social Login Joomla

Need more Help?


Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!