Provide a contractor access to a MySQL database.

Here is a video of where I am stuck http://screencast.com/t/sBBpI2aX.  Thanks for the assistance.
frugalmuleAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Julian HansenCommented:
This should be fairly straight forward

1. Create the user account for the contractor and giver her access to the database you want her to have access to

2. Provider her with a link to the PHPMyAdmin URL for your database

When she logs in to PHPMyAdmin she will only be able to see the database she has access to.
0
frugalmuleAuthor Commented:
The direct link is this one which directs me to a cpanel login.  When I put the username i created in there and the password i created for a specific database, it does not let me in.

http://cpanel.goshawk.arvixe.com/cpsess708190385/3rdparty/phpMyAdmin/index.php#PMAURL-2:db_structure.php?db=tpenner_131007&table=&server=1&target=&token=4e2a2aa7dd542c572ae55dd9024c3a42
0
Julian HansenCommented:
The direct link is this one which directs me to a cpanel login
You need to find out what the direct link is for PHPMyAdmin - not the cpanel link.

Best solution is to ask your ISP what the direct link is as each tends to set this up differently.

Once you have the PHPMyAdmin link - the rest is as above.
0
Kim WalkerWeb Programmer/TechnicianCommented:
I don't know about cpanel, but Plesk Panel does not have a direct link to PHPMyAdmin. You must install an additional copy of PHPMyAdmin into a publicly available folder in order to access it directly.
0
Chris StanyonWebDevCommented:
Another option, if your server is setup for remote database access, is to not use the PHPMyAdmin interface at all. Ask them to download install a mySQL client, such as the mySQL WorkBench - I find it's actually much quicker than using PHPMyAdmin because it's not web based - your contractor would just set up a connection using the address, username and password you provide, and connect directly to your database.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.