MySQL table permissions
Is there a way to grant permissions to a specific table in a MySQL database? Is there a way for a specific user to do this (i.e. not root)? I have a client that is wanting a user to have access to a specific table in his database, but only that database. I can enable access to the entire database, but don't know how to prevent access to just that one table. Is there a way that he can do this, without using the 'mysql' database?Thanks