UK WEB HOSTING FORUM FOR DISCUSSION ON WEB HOSTING SERVICE AND SUPPORT
LINUX HOSTING WINDOWS HOSTING PACKAGES SHOPPING CART OSCOMMERCE ZEN CART AGORA
ECOMMERCE HOSTING ASP MSSQL FRONTPAGE HOSTING PHP MYSQL HOSTING DISCUSSION FORUM
CPANEL RESELLER HOSTING DEDICATED SERVER VPS HOSTING PLESK VIRTUOZZO
Quick Search
Your forum announcement here!

  UK Web Hosting | Dedicated Server Windows and Linux VPS Forum > Technical Support > Control Panel Questions

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 07-03-2007, 15:44
Junior Member
 
Join Date: Mar 2007
Posts: 16
Default MYSQL database connection

Hi

I have a webdeveloper writing something in PHP MYSQL they will need to get acces to my database - can they do this without having access to my entire control panel - what are the passwords database name etc (where do I find them please)
Reply With Quote
  #2 (permalink)  
Old 07-03-2007, 18:11
eUKhost.com's Avatar
Chief Marketing Officer
 
Join Date: Sep 2005
Posts: 4,261
Send a message via AIM to eUKhost.com Send a message via MSN to eUKhost.com
Default

Yep. You can allow them access to your database. Simply open your cpanel and click on MySQL Database Management icon. In MySQL section you will see an option at the bottom named "access hosts". Add his IP over there and then give him IP of the server, database name, database username and database password.

Make sure that you ask him to provide IP address of his machine by visiting whatismyip.com. If he says that his ISP allocated dynamic IPs to his machine then put "%" ( without quotes ) in access hosts section of your cpanel control panel. If you need help in creating database and assigning username to the database then go through cpanel tutorials located at http://www.eukhost.com/support/cpanel.php
__________________
UK Web Hosting || Business Hosting || eUKhost Knowledgebase
Toll Free : 0808 262 0255 || MSN : mark @ eukhost.com || AIM : eukmark
A bunch of Sheep led by a Lion is better than a bunch of Lions led by a Sheep.
__________________________________________________

Great Opportunity :: Join our Affiliate Program for FREE and earn 20% commission on each referral.
Reply With Quote
  #3 (permalink)  
Old 07-03-2007, 18:38
Premium Member
 
Join Date: Jan 2007
Posts: 209
Default

Hello,
As Mark pointed you can allow their computer to connect to the database by following his suggestion. But before that, create the database, then create/assign a user to that database. All this can be done via the "mySQL database management" section as mentioned in the reply above. So you have to give just this database name, username of the user you create here and the password for this database user. They should be able to connect to it then.

Regds
IJ
Reply With Quote
Reply



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

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

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


All times are GMT. The time now is 04:14.

 

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by Web Hosting 3.1.0
Copyright © 2001-2008, eUKhost.com. All rights reserved.

 
Site Map

knowledgebase articles

popular blog categories