29.03.2010, 21:58
Quote:
Originally Posted by iLinx
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 Code:
GRANT ALL PRIVILEGES ON 'DATABASE' . * TO 'USER'@'%' |