mysql database user permissions - access by table

Category: Databases

sdegele
Asked:
2012-10-11 2:29 am EST

Hits: 1,337
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 http://www.inmotionhosting.com/support/community-support/databases/mysql-grant-access-to-specific-table

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.

OTHER ANSWERS

0

jamesr
Staff
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?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

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: support@InMotionHosting.com
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!