homepage Welcome to WebmasterWorld Guest from 54.197.111.87
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Visit PubCon.com
Home / Forums Index / WebmasterWorld / New To Web Development
Forum Library, Charter, Moderators: brotherhood of lan & mack

New To Web Development Forum

    
Connecting to a MySQL database using Xampp
Connecting to a MySQL database using Xampp
tomhumf




msg:3748704
 8:04 pm on Sep 20, 2008 (gmt 0)

Hi,

I'm trying to use Xampp with my site to test changes offline. The database connection set as localhost works fine for the site on my domain. I can see that as the database and website are in the same place this would work.

I am presuming localhost needs to be changed when using xammp, to the IP address where the database is. I tried changing localhost to the Shared Ip Address listed in my cpanel but this didn't work. Am I doing the right thing?

I also tried setting the username and password in the xampp admin to the ones used for my site. This gives me an access violation popup, so not sure what to do there.

Can anyone point me in the right direction to get this working?

Thanks

 

mack




msg:3749019
 12:34 pm on Sep 21, 2008 (gmt 0)

Are you trying to connect to your live (remote) database but viewing your development site in Xampp? If so you may need to allow your IP address within the cpanel area of the remote server. By default Mysql will only allow connections from localhost, you will need to specify your Ip address as an allowed connection. This is a mysql security feaure.

Mack.

tomhumf




msg:3749224
 10:06 pm on Sep 21, 2008 (gmt 0)

thanks Mack!

Yes I was trying to connect to my live database. I added my IP address in the remote mysql section of cpanel and it sprung into life.

nice one :)

mack




msg:3749736
 6:54 pm on Sep 22, 2008 (gmt 0)

Glad to help. :)

Mack.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / WebmasterWorld / New To Web Development
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved