Jump to content


Photo

What is address or name of MDD's MySQL server?


  • Please log in to reply
5 replies to this topic

#1 Yone

Yone

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 30 November 2011 - 09:47 PM

I'm using php to connect to my MySQL database, and I need to know what the address of the database server is.

With 1&1 I had:

$server = "db1437.perfora.net";

in my php code.

So, please, what is the equivalent $server for MDDHosting?

  • 0

#2 kuemerle5

kuemerle5

    Member

  • Clients
  • PipPip
  • 70 posts
  • Gender:Male

Posted 30 November 2011 - 09:55 PM

Since the MySQL and web server run on the same machine, you can just put in "localhost" for the server address.
  • 0

#3 Scott

Scott

    MDDHosting Staff

  • Staff Administrator
  • PipPipPipPip
  • 421 posts
  • Gender:Male

Posted 30 November 2011 - 11:03 PM

Point of interest for those who are interested,
localhost
is correct as well as
127.0.0.1
(the default loopback address for all servers). Your domain name or the servers host name can also be used, but is not recommended as it will cause issues if your account is ever moved to another server, or in the event of an unexpected DNS change.
  • 0
Scott S - MDDHosting LLC - Providing Hosting since 2007
Scalable shared hosting plans in the cloud! Check them out!
Highly Available Cloud Shared, Reseller, and VPS
http://www.mddhosting.com/

#4 Psionmark

Psionmark

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 13 December 2011 - 01:07 PM

Point of interest for those who are interested,

localhost
is correct as well as
127.0.0.1
(the default loopback address for all servers). Your domain name or the servers host name can also be used, but is not recommended as it will cause issues if your account is ever moved to another server, or in the event of an unexpected DNS change.


I'm trying out an external auto backup solution (backupmachine.com). This requires an IP Address. I've tried that associated with my site (173.248.188.177), along with the database credentials, but it always fails authentication.

Any idea how I give it access?

Regards,

Mark
  • 0

#5 kuemerle5

kuemerle5

    Member

  • Clients
  • PipPip
  • 70 posts
  • Gender:Male

Posted 13 December 2011 - 01:40 PM

There is an option in cPanel to allow external hosts to connect to your MySQL server. Click the link for "Remote MySQL" and add the hostname or IP address of the computer that's going to be performing your backups.
  • 0

#6 Psionmark

Psionmark

    Newbie

  • Members
  • Pip
  • 2 posts

Posted 13 December 2011 - 01:45 PM

There is an option in cPanel to allow external hosts to connect to your MySQL server. Click the link for "Remote MySQL" and add the hostname or IP address of the computer that's going to be performing your backups.


That did the trick :)

Thanks very much for the quick reply.

Mark
  • 0




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users