|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
October 16th, 2006, 11:48 PM
|
|||
|
|||
|
Restrict mysql user to access databases
How can I restrict users to access only few databases ? I have 10 databases, and I want tht user X should only b allowed to access 2 of those 10 databases ?
How can i do that ? I have dedicated linux server
|
|
#2
October 17th, 2006, 03:29 PM
|
|||
|
|||
|
What do you mean by saying "access only two of the ten databases"?? Don't you have some passwords for them or something?? Besides, you determinate which databases can the user access through your code(writen in a language-->php, asp->for web design, java, c++->for applications--windows or console). In order to help you, say exactly what you mean!!
Costas
|
|
#3
October 18th, 2006, 10:13 AM
|
||||
|
||||
|
I think you're looking for MySQL's GRANT.
Code:
GRANT ALL ON db_name.* TO user_name IDENTIFIED BY 'password';
__________________
Daryl's Homepage | My Blogroll | My Profile | Firefox supporter! DevArticles Forum Moderator "The net is a waste of time, and that's exactly what's right about it." -- William Gibson
|
|
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > Restrict mysql user to access databases |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
