MySQL grant access to specific table

Avatar
  • Answered
How to I set up user privileges in MySQL to grant access for a MySQL user to only a specific table?
Avatar
Scott
Hello roundr,

Database user management is done via the PhpMyAdmin tool found in the cPanel. While it does allow the restriction of users in regards to permissions, they are for the entire database and not on specific tables. This is by our shared server design.

It can be done on VPS and Dedicated servers with MySQL root access, however.

Best Regards,
Scott M