MySQL User restricted to one databases table?
#3

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'@'%'
Ok 1 question: How to create users :P
Reply


Messages In This Thread
MySQL User restricted to one databases table? - by Torran - 29.03.2010, 21:38
Re: MySQL User restricted to one databases table? - by iLinx - 29.03.2010, 21:47
Re: MySQL User restricted to one databases table? - by Torran - 29.03.2010, 21:58
Re: MySQL User restricted to one databases table? - by iLinx - 29.03.2010, 22:34
Re: MySQL User restricted to one databases table? - by ineoncore - 30.03.2010, 00:48
Re: MySQL User restricted to one databases table? - by mamorunl - 30.03.2010, 11:55
Re: MySQL User restricted to one databases table? - by Zh3r0 - 30.03.2010, 13:20

Forum Jump:


Users browsing this thread: 1 Guest(s)