Connecting to Databases in LPCP

From Lunarpages Web Hosting Wiki
Jump to: navigation, search

When using your MySQL or PostgreSQL databases with an LPCP powered web hosting account, you will no longer connect using localhost as the default host for the databases in question. All LPCP hosting account servers use a separate database server, to increase reliability and performance with your web hosting plan of choice.

What is My Database Server?

The details on how to connect to your databases are in your welcome e-mail, which was sent to you when your web hosting account was created. They can be found in the category labeled, "Database Instructions".

Database-instu.png

At this time the database server you might need to use could be:

  • lpsql01.lunariffic.com 216.227.216.46
  • lpsql02.lunariffic.com 209.200.244.80
  • lpsql03.lunariffic.com 74.50.13.226
  • lpsql04.lunariffic.com 209.200.229.220

As new servers are rolled out into production, your database server might be different. You can confirm your database server for your LPCP powered web hosting account in your welcome e-mail or by logging into your LPCP and checking on the right side under System Information.

Lpcp mysql ip.jpg

Database Details for Third Party Scripts and Services

When setting up a third-party script or service, you must often plug in details about your database relationship so that the script can use the database in question. In most cases, you should plugin the details like this:

  • hostname: Your Host Name (as mentioned above)
  • user: serverprefix_username
  • database name: serverprefix_databasename
  • password: the database user's password

Example Setup Details

Also, be sure that you have also assigned a database user to the database you wish to use. So, for an example, you settings might look something like this:

  • hostname: lpsql01.lunariffic.com (or 216.227.216.46)
  • username: serverna_mydatabaseuser
  • database: serverna_mydatabase
  • password: pinkbunny
Share |
Want to read this in another language?