MySQL server problems with php

MitchEvans

I have some php working fine on my local computer but I come to upload it to my web space on the Internet and it won't connect the MySQL. Has anyone ideas of how to change or do this.

My code is shown below:

//connect to database
mysql_connect("localhost","root","computer") or die("Unable to establish Connection");

//specify database
mysql_select_db("mitch") or die("Unable to select database");

RedMaster

MitchEvans wrote:
I have some php working fine on my local computer but I come to upload it to my web space on the Internet and it won't connect the MySQL. Has anyone ideas of how to change or do this.

My code is shown below:

//connect to database
mysql_connect("localhost","root","computer");

//specify database
mysql_select_db("mitch") or die("Unable to select database");

Hmm where are your vars? 🙂
Try this code:

$conn = mysql_connect("localhost","root","computer") or die(mysql_error()); 

//specify database 
$select_db = mysql_select_db("mitch", $conn) or die("Unable to select database");

😉

MitchEvans

It now says "Access denied for user 'root'@'localhost' (using password: YES)"

Is it something to do with the fact that it's local maybe? Because i'm trying to put it online.

RedMaster

MitchEvans wrote:
It now says "Access denied for user 'root'@'localhost' (using password: YES)"

Is it something to do with the fact that it's local maybe? Because i'm trying to put it online.

If you want to upload the scripts on another server you myst change your host, user and pass with the server.
That means that you must to change that row:

 $conn = mysql_connect("localhost","root","computer") or die(mysql_error());

Especialy in the brackets 😉

MitchEvans

I have managed to sort out the exact root of my server online and it's working fine, thanks for all your help it's most appreciated,

Cheers,

Mitch.