29.03.2010, 21:47
You can set a users privileges both locally (for a database) or globally (for the whole thing), generally you can do it with a query through PHP, through shell if you have access, or through a client like PHPMyAdmin
Here's an example query which will set all permissions to a user on a local database
Here's an example query which will set all permissions to a user on a local database
Code:
GRANT ALL PRIVILEGES ON 'DATABASE' . * TO 'USER'@'%'