I am using phpMyAdmin to manage a database and want to allow different users to access and edit (only) their own tables in the DB. I do not have privileges on the DB beyond being able to add/remove/edit tables, but I believe that there is still a way that I might achieve my goal. Can anyone advise please?
You can find answer to your question over here: http://stackoverflow.com/questions/9780637/how-can-i-restrict-a-mysql-user-to-a-particular-tables
Thank you Peter.