SA-MP Forums

Go Back   SA-MP Forums > Other > Everything and Nothing

Reply
 
Thread Tools Display Modes
Old 29/03/2010, 09:38 PM   #1
Torran
High-roller
 
Join Date: Jan 2010
Posts: 1,779
Reputation: 1
Default MySQL User restricted to one databases table?

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?
Torran is offline   Reply With Quote
Old 29/03/2010, 09:47 PM   #2
iLinx
High-roller
 
Join Date: Jun 2009
Location: Toronto
Posts: 1,498
Reputation: 157
Default Re: MySQL User restricted to one databases table?

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'@'%'
__________________
Servers in Arizona, Virginia, Quebec (Canada), United Kingdom, Netherlands. Over 12,000 served. Free cPanel web hosting is included with ALL servers. ********. *******.
iLinx is offline   Reply With Quote
Old 29/03/2010, 09:58 PM   #3
Torran
High-roller
 
Join Date: Jan 2010
Posts: 1,779
Reputation: 1
Default Re: MySQL User restricted to one databases table?

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
Torran is offline   Reply With Quote
Old 29/03/2010, 10:34 PM   #4
iLinx
High-roller
 
Join Date: Jun 2009
Location: Toronto
Posts: 1,498
Reputation: 157
Default Re: MySQL User restricted to one databases table?

I recommend you play around in PHPMyAdmin under the privileges tab.
__________________
Servers in Arizona, Virginia, Quebec (Canada), United Kingdom, Netherlands. Over 12,000 served. Free cPanel web hosting is included with ALL servers. ********. *******.
iLinx is offline   Reply With Quote
Old 30/03/2010, 12:48 AM   #5
ineoncore
Big Clucker
 
Join Date: Feb 2010
Posts: 162
Reputation: 0
Default Re: MySQL User restricted to one databases table?

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 youtube and ******
You might find something you need
ineoncore is offline   Reply With Quote
Old 30/03/2010, 11:55 AM   #6
mamorunl
High-roller
 
mamorunl's Avatar
 
Join Date: Feb 2007
Location: Groningen/Netherlands
Posts: 1,938
Reputation: 2246
Default Re: MySQL User restricted to one databases table?

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 youtube and ******
You might find something you need
19.788 per day. Not 65. How do I know? I am just great
mamorunl is offline   Reply With Quote
Old 30/03/2010, 01:20 PM   #7
Zh3r0
High-roller
 
Join Date: Mar 2008
Posts: 4,512
Reputation: 398
Default Re: MySQL User restricted to one databases table?

Quote:
Originally Posted by mamoru
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 youtube and ******
You might find something you need
19.788 per day. Not 65. How do I know? I am just great
The "View Profile" button just spoke.
__________________
Zh3r0 is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[Tutorial] [TUT] Teams - Setting up teams - Team restricted vehicles - Team Restricted base retart441 Tutorials 79 08/02/2015 10:43 AM
Tool to manage MySQL databases RoamPT Everything and Nothing 7 17/04/2010 12:39 PM
[Solved] Getting data into MySQL table easier. Miguel Help Archive 2 24/01/2010 01:15 AM
MySQL vs basic user data base Jimmyhead521 Server Support 18 26/12/2009 10:28 AM
MySQL table problem. M1GU3L Help Archive 14 06/12/2009 05:19 PM


All times are GMT. The time now is 01:28 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.