icon Learn how to get the most out of Surmunity - read our forum tips here! | Welcome! Please register to access all of our features.
Old June 5th, 2006, 2:25 PM   #1 (permalink)
Registered User
Seasoned Poster
 
steveorg's Avatar
 
Joined in May 2004
Lives in Wrong Coast
Hosted on pass77
58 posts
Gave thanks: 0
Thanked 1 Time in 1 Post
Limiting access in in phpMyadmin

Is there any way to give someone access to a single database in phpMyadmin without giving access to the cPanel? Thanks.
steveorg is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old June 5th, 2006, 2:29 PM   #2 (permalink)
Registered User
Comfy Contributor
 
Joined in Oct 2004
124 posts
Gave thanks: 1
Thanked 0 times
You could create a user which can connect from a remote host (I would recommend giveing it a fixed remote host) and give the person this information.

Also you could try to give the person a user/password (see phpmyadmin, or in cpanel the database section) and it should not be active as a cpanel user/password
marlov is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old June 5th, 2006, 3:09 PM   #3 (permalink)
Registered User
Seasoned Poster
 
steveorg's Avatar
 
Joined in May 2004
Lives in Wrong Coast
Hosted on pass77
58 posts
Gave thanks: 0
Thanked 1 Time in 1 Post
Thanks Martijn.
Quote:
Originally Posted by marlov
You could create a user which can connect from a remote host (I would recommend giveing it a fixed remote host) and give the person this information.
How do you create a remote host? Thanks.
steveorg is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old June 5th, 2006, 3:16 PM   #4 (permalink)
Registered User
Comfy Contributor
 
Joined in Oct 2004
124 posts
Gave thanks: 1
Thanked 0 times
Whell if i remember correctly (I don't have any acces to cPanel atm), it is in the submenu called databases, then you can create an user, and add a host to it... (thought hosts were further down on same page)
marlov is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old June 5th, 2006, 3:25 PM   #5 (permalink)
Registered User
Seasoned Poster
 
steveorg's Avatar
 
Joined in May 2004
Lives in Wrong Coast
Hosted on pass77
58 posts
Gave thanks: 0
Thanked 1 Time in 1 Post
So far so good, I added the host. How do I create a link to phpmyadmin? Thanks again.
__________________
Steve
steveorg is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old June 5th, 2006, 3:31 PM   #6 (permalink)
Registered User
Comfy Contributor
 
Joined in Oct 2004
124 posts
Gave thanks: 1
Thanked 0 times
For PHPMyAdmin you could just download an instance and configure it in a way that it connects to the database useing the user's details, user, pass etc.

This wouldn't require him to have access to cpanel.
marlov is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old June 5th, 2006, 3:38 PM   #7 (permalink)
Registered User
Seasoned Poster
 
steveorg's Avatar
 
Joined in May 2004
Lives in Wrong Coast
Hosted on pass77
58 posts
Gave thanks: 0
Thanked 1 Time in 1 Post
How do you download an instance? (I'm glad your sig says something about stupid questions.)
__________________
Steve
steveorg is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old June 5th, 2006, 3:41 PM   #8 (permalink)
Registered User
Comfy Contributor
 
Joined in Oct 2004
124 posts
Gave thanks: 1
Thanked 0 times
see http://www.phpmyadmin.net
marlov is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old June 5th, 2006, 4:03 PM   #9 (permalink)
Registered User
Seasoned Poster
 
steveorg's Avatar
 
Joined in May 2004
Lives in Wrong Coast
Hosted on pass77
58 posts
Gave thanks: 0
Thanked 1 Time in 1 Post
I checked the site and couldn't find any reference to downloading an instance. Are you suggesting that I install another copy of phpmyadmin and configure it to only access the one database?
__________________
Steve
steveorg is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


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

Advanced Search
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On