mysql database user permissions - access by table
Category: Databases
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..
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..
OTHER ANSWERS
|
0
|
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. |
Like this Question?
Tweet
Latest Questions
If you need some help, submit your question to our Community!
We guarantee a response within 60 minutes (8am - 9pm EST, Monday - Friday)
Recent QuestionsNeed 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 |

