Article Discussion: Creating Users and Setting Permissions in MySQL

Creating Users and Setting Permissions in MySQL If you have any questions or comments about this article then please post them here. If you'd like to comments directed at only Ryan (the author of the article) then make sure you add something like "To Ryan: " before your question.

You can read the article here .

Hi Have a question relating to setting up users for our customers on a shared server environment.

Is it standard practice to give the user of the database (site owner) one set of permissions which i figure should be:

select, insert, update,delete, create, drop On database to user@localhost

and create one for them to put into their php pages that call the database from the website (which would be the one their visitors are using)? like an IUSER_ but for mysql?

If so, what should the bare minimum permissions be for this username. I think insert, update, delete and select, but I am not sure.

Thanks for your help.

If root has all privileges and cannot , however, successfully grant any privileges to any user, what could be the problem?

Thanks.