Limiting access in in phpMyadmin - Page 3

steveorg · June 7th, 2006, 10:33 AM

I think that I've just entered the twilight zone. It's now working! All I did was reboot this morning.

I specified a db as explained earlier in this thread. However, there is a "Databases" link that gives the user access to all dbs. Is there a way to disable the databases link?

It's too bad that there isn't a more robust permission system. I'd like to be able to create users that have access to specified databases.

Haugland - I appreciate your kind offer.

H · June 7th, 2006, 10:48 AM

I'm not sure of the line number anymore -- may have changed -- but line 75 should be a line where you specify one database to work with. That will limit them to the one database.

steveorg · June 7th, 2006, 11:06 AM

I had already made the change. On my version it's line 51. -$cfg['Servers'][$i]['only_db'].

Where I went wrong is the user, which has permissions to all dbs. I changed it to the speciic user and all is well.

Thanks to all that have helped!

marlov · June 7th, 2006, 1:24 PM

Wow my first GOOD helpout

Azyura · May 28th, 2007, 1:01 PM

I thought it would be the best to post here so you know what I'm talking about.

So I got PHPMyAdmin installed and the one hostee I have at the moment can access it. I've added the hostee's details into the config file of PHPMyAdmin so that only this user can access the installation. I'd like to give more users the possibility to reach that one installation (instead of uploading another one every time, it eats up about 12 MB of space!). Is this possible? I haven't found any information about that.

June 7th, 2006, 10:33 AM	#19 (permalink)
steveorg Registered User Seasoned Poster Joined in May 2004 Lives in Wrong Coast Hosted on pass77 58 posts Gave thanks: 0 Thanked 1 Time in 1 Post	I think that I've just entered the twilight zone. It's now working! All I did was reboot this morning. I specified a db as explained earlier in this thread. However, there is a "Databases" link that gives the user access to all dbs. Is there a way to disable the databases link? It's too bad that there isn't a more robust permission system. I'd like to be able to create users that have access to specified databases. Haugland - I appreciate your kind offer. __________________ Steve

June 7th, 2006, 11:06 AM	#21 (permalink)
steveorg Registered User Seasoned Poster Joined in May 2004 Lives in Wrong Coast Hosted on pass77 58 posts Gave thanks: 0 Thanked 1 Time in 1 Post	I had already made the change. On my version it's line 51. -$cfg['Servers'][$i]['only_db']. Where I went wrong is the user, which has permissions to all dbs. I changed it to the speciic user and all is well. Thanks to all that have helped! __________________ Steve

June 7th, 2006, 1:24 PM	#22 (permalink)
marlov Registered User Comfy Contributor Joined in Oct 2004 124 posts Gave thanks: 1 Thanked 0 times	Wow my first GOOD helpout __________________ de-uitgeverij.com SH105 72.29.93.156

May 28th, 2007, 1:01 PM	#23 (permalink)
Azyura Registered User Fresh Surpasser Joined in Feb 2007 Lives in Germany Hosted on Pass70 25 posts Gave thanks: 2 Thanked 0 times	I thought it would be the best to post here so you know what I'm talking about. So I got PHPMyAdmin installed and the one hostee I have at the moment can access it. I've added the hostee's details into the config file of PHPMyAdmin so that only this user can access the installation. I'd like to give more users the possibility to reach that one installation (instead of uploading another one every time, it eats up about 12 MB of space!). Is this possible? I haven't found any information about that. __________________

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

June 7th, 2006, 10:48 AM	#20 (permalink)
H after g, before i Super #1 Joined in Jul 2004 Hosted on Gojira 7,870 posts Gave thanks: 44 Thanked 127 times	I'm not sure of the line number anymore -- may have changed -- but line 75 should be a line where you specify one database to work with. That will limit them to the one database.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)