php database help, database hosted on separate server than web host

Question

Hi I am making a login/register database. I am not hosting the database on the same server so how do I make it point to my separate domain? Also if you can tell me what the root is pointing to... Thx

Here are my files:

db.php

<?php
$connection = mysql_connect('localhost', 'root', '');
if (!$connection){
die("Database Connection Failed" . mysql_error());
}
$select_db = mysql_select_db('register');
if (!$select_db){
die("Database Selection Failed" . mysql_error());
}
?>

Links (my scripts and original scripts): https://docs.google.com/document/d/1u60X_mKd9z548qrh_VjdyTx3hziiZiYPLUa_rJX11mQ/edit?usp=sharing

change localhost to the server's domain or IP. You should look into using mysqli or pdo if just starting out. — chris85
– chris85, Commented Apr 22, 2016 at 1:16
Simply amend the mysql_connect parameters to match your database server's host name, username and password. IP address should work fine, but also machine name or DNS entry, depending on your network setup. — ManoDestra
– ManoDestra, Commented Apr 22, 2016 at 3:14

Community · Accepted Answer · 2017-05-23 12:23:54Z

1

For starters, DON'T USE mysql_connect()! Use either mysqli or PDO. Second, don't have your application log in to MySQL as root; create an application-specific unprivileged user (with a password!) for this purpose.

You'll need to create your unprivileged user with connect privilege from the web server's IP or DNS address, and instead of connecting to localhost your PHP will need to connect to the DB server's IP or DNS address, like so:

$dsn = "mysql:host=mysqlserver.mynetwork.com;dbname=register";
try
{
    $conn = new PDO($dsn, $appuser, $apppasswd);
}
catch (PDOException $e)
{
    echo 'Connection failed: ' . $e->getMessage();
}

edited May 23, 2017 at 12:23

CommunityBot

11 silver badge

answered Apr 22, 2016 at 1:22

Darwin von Corax

5,2643 gold badges20 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user2168287 · Accepted Answer · 2016-04-22 01:20:14Z

0

You could try the following example

$server = "192.168.1.1"; //server name or IP Address 
$username = "root"; //database username
$password = "password"; //database password
$database = "mydatabase";   //database to connect to

$connection = mysqli_connect( $server, $username, $password, $database);

if (!$connection){
   die("Database Connection Failed" . mysqli_error());
}

else{

//sql statement

}

mysqli_close($connection);

Thanks

answered Apr 22, 2016 at 1:20

user2168287

911 silver badge12 bronze badges

1 Comment

user2168287 Over a year ago

As @chris85 mention you should look at using mysqli. I have updated my answer to reflect this

Collectives™ on Stack Overflow

php database help, database hosted on separate server than web host

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related