Can't connect to MySQL remotely

Can't connect to MySQL from home.

Page 1 of 1

4 Replies - 3208 Views - Last Post: 07 May 2009 - 01:28 PM Rate Topic: -----

#1 J9710  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 19
  • Joined: 07-May 09

Can't connect to MySQL remotely

Posted 07 May 2009 - 12:06 PM

Hi.

So im trying to connect to my MySQL database from home. I use Wamp to test all of my php files etc and am unsure how to use it to connect to my database (on my college server).

At the moment i just hit 'Start all services' in wamp and hope for the best!


Below is the code im using:

DEFINE ('DB_USER', 'user here');
DEFINE ('DB_PASSWORD', 'pass here');
DEFINE ('DB_HOST', 'ip here');
DEFINE ('DB_NAME', 'dbase');

I think it may be that im doing something wrong in wampserver though but any advice would be appreciated.

Is This A Good Question/Topic? 0
  • +

Replies To: Can't connect to MySQL remotely

#2 RPGonzo  Icon User is offline

  • // Note to self: hmphh .... I forgot
  • member icon

Reputation: 151
  • View blog
  • Posts: 954
  • Joined: 16-March 09

Re: Can't connect to MySQL remotely

Posted 07 May 2009 - 12:10 PM

Make sure your host allows remote connections ...

I know on mine i had to go in and allow my ISP to be able to remotely connect .... there should be a deny error that will give

Quote

access denied for user joeschmoe with password yes/no


sometimes after your username it will give more info about your isp mine has like switch1.comcast.httx01. bla bla bla

Just a guess and something to check ...
Was This Post Helpful? 0
  • +
  • -

#3 J9710  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 19
  • Joined: 07-May 09

Re: Can't connect to MySQL remotely

Posted 07 May 2009 - 12:37 PM

Yeah i get that password yes/no error when i try and submit information on my feedback page, which is supposed to be connected to the database.

Im pretty new to this, i dont suppose you could go into a bit more detail about how i check if my ISP would allow remote connections? This wamp doesn't seem to have many options.

Btw i can get onto the server and view my database, im just stuck with linking wamp to it so i can send new data to it.

Thanks

This post has been edited by J9710: 07 May 2009 - 12:39 PM

Was This Post Helpful? 0
  • +
  • -

#4 RPGonzo  Icon User is offline

  • // Note to self: hmphh .... I forgot
  • member icon

Reputation: 151
  • View blog
  • Posts: 954
  • Joined: 16-March 09

Re: Can't connect to MySQL remotely

Posted 07 May 2009 - 12:47 PM

Umm personally i have never used WAMP ... i always test live lol i just know about the remote connection because i use SQLyog and thats when i ran into the issue.

On mine it was simply of going into the MySQL server part and enabling a user to connect remotely while using a certain address...

With wamp it could be simplier but i would wait for someone who is experienced with the program to let you know more ;) sorry i wasn't much help after i posted i was thinking hmmm i dont know wamp haha
Was This Post Helpful? 0
  • +
  • -

#5 J9710  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 19
  • Joined: 07-May 09

Re: Can't connect to MySQL remotely

Posted 07 May 2009 - 01:28 PM

Not a problem. Thanks for the replies.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1