Results 1 to 8 of 8
Thread: phpMyAdmin - Help
-
01-01-2003, 02:27 AM #1Disabled
- Join Date
- Aug 2002
- Posts
- 1,216
phpMyAdmin - Help
Hello everyone, I've looked through out all of the phpmyadmin document's although I haven't found any information on how to make it so when users login they only have control over _their_ databases, and only see _their_ database.
For example I login to phpmyadmin with the user demo and the password demo. On the left I can see every database, and control it etc.
How can I make it so when the user "demo" logs in _only_ he has access to his database (besides root) and he only sees his database.
Anyone have any info? All appreciated thanks! .
-
01-01-2003, 09:30 AM #2Junior Guru
- Join Date
- Jan 2002
- Posts
- 214
When I use phpMyAdmin it's automatically like that.
Web-cp: an open source control panel: http://www.web-cp.net
-
01-01-2003, 09:43 AM #3Aspiring Evangelist
- Join Date
- Aug 2001
- Location
- Indiana
- Posts
- 421
Re: phpMyAdmin - Help
Originally posted by ChickenSteak
Hello everyone, I've looked through out all of the phpmyadmin document's although I haven't found any information on how to make it so when users login they only have control over _their_ databases, and only see _their_ database.
For example I login to phpmyadmin with the user demo and the password demo. On the left I can see every database, and control it etc.
How can I make it so when the user "demo" logs in _only_ he has access to his database (besides root) and he only sees his database.
Anyone have any info? All appreciated thanks! .
I'm guessing this is a non-CPanel machine....?"Last year, some resourceful software enthusiasts cracked Sony Music's proprietary technology simply by scribbling around the edges of the disc with a Magic Marker pen, thus enabling playback on any device." - news.com
-
01-01-2003, 09:45 AM #4Aspiring Evangelist
- Join Date
- Oct 2002
- Location
- Tel-Aviv, Israel
- Posts
- 436
you have to configure the grant tables in the mysql database read the documents about it at mysql.com
Uadm.com - Unix Administration, Security and Support.
http://www.uadm.com
"Unix is user friendly; it's just picky about who its friends are."
-
01-01-2003, 01:36 PM #5Disabled
- Join Date
- Aug 2002
- Posts
- 1,216
WebMastTroy - Yes
Rcs - I've checked that out, and pretty sure at least _that_ part is right . Although i'll check it again .
-
01-01-2003, 02:09 PM #6WHT Addict
- Join Date
- Jun 2002
- Posts
- 146
Hmmm...If you are sure your grant tables are Ok then are you by chance using $cfgServers[$i]['auth_type'] = 'config' ?
-
01-01-2003, 02:15 PM #7Disabled
- Join Date
- Aug 2002
- Posts
- 1,216
A:\ - I'm using http.
I have got it all working now everyone, thanks!
(For some reason the grants I configured didn't take effect, so the problem was I had to reload the mysql database.
-
01-01-2003, 02:26 PM #8WHT Addict
- Join Date
- Jun 2002
- Posts
- 146
Originally posted by ChickenSteak
(For some reason the grants I configured didn't take effect, so the problem was I had to reload the mysql database.