MySQL User restricted to one databases table? - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Other (https://sampforum.blast.hk/forumdisplay.php?fid=7)
+--- Forum: Everything and Nothing (https://sampforum.blast.hk/forumdisplay.php?fid=23)
+--- Thread: MySQL User restricted to one databases table? (/showthread.php?tid=137730)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Other (https://sampforum.blast.hk/forumdisplay.php?fid=7)
+--- Forum: Everything and Nothing (https://sampforum.blast.hk/forumdisplay.php?fid=23)
+--- Thread: MySQL User restricted to one databases table? (/showthread.php?tid=137730)
MySQL User restricted to one databases table? - Torran - 29.03.2010
Is this possible like on FTP stuff?
Like on FTP you can setup a FTP user and restrict them to certain bits,
Is this possible with MySQL? Like restrict them to only be able to edit a certain table?
Or does anyone know any PHP tutorials,
So i can like learn to do this threw my website?
Re: MySQL User restricted to one databases table? - iLinx - 29.03.2010
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'@'%'
Re: MySQL User restricted to one databases table? - Torran - 29.03.2010
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'@'%' |
Re: MySQL User restricted to one databases table? - iLinx - 29.03.2010
I recommend you play around in PHPMyAdmin under the privileges tab.
Re: MySQL User restricted to one databases table? - ineoncore - 30.03.2010
Wow, okay.
you got many posts. I mean lots. 1306 (19.788 per day)
that like wow. You make like 65 posts per day?
anyway ontopic
There is php+mysql tutorials all over ******* and ******
You might find something you need
Re: MySQL User restricted to one databases table? - mamorunl - 30.03.2010
Quote:
|
Originally Posted by ineoncore
Wow, okay.
you got many posts. I mean lots. 1306 (19.788 per day) that like wow. You make like 65 posts per day? anyway ontopic There is php+mysql tutorials all over ******* and ****** You might find something you need |
Re: MySQL User restricted to one databases table? - Zh3r0 - 30.03.2010
Quote:
|
Originally Posted by mamoru
Quote:
|