mysql help, seriously weird problem
Posted: 2005-10-28 07:05pm
Can anyone figure this one out? I've got a database and web server set up on one machine, I set up both on my laptop for demo purposes, database seems to be working, I can log into phpMyAdmin fine, my database imported fine too, however when I try to connect to it I get an error.
Now, as far as I can tell, everything is set up exactly as it was on the other machine. the mySQL version on the first machine is 4.1.11 where as the newer one is 4.1.15, but that should have only had an impact on importing the database (I think), which worked fine anyway.
This is the contents of connection.php
phpMyAdmin says:
"Welcome to phpMyAdmin 2.6.2
MySQL 4.1.15-nt running on localhost as root@localhost"
The output whenever connection.php is included:
"Connection Error"
What have I forgotten to do?
Also of note: The connection works fine on the other machine.
Now, as far as I can tell, everything is set up exactly as it was on the other machine. the mySQL version on the first machine is 4.1.11 where as the newer one is 4.1.15, but that should have only had an impact on importing the database (I think), which worked fine anyway.
This is the contents of connection.php
Code: Select all
<?
// Connection file contains variables that control the connection to mySQL.
// $mysql_host: the host machine containing mySQL server ("localhost" if same as webserver)
// $mysql_username: Username/Login for mySQL database
// $mysql_password: Password for mySQL username/login
// $mysql_db: name of the database to be used.
//
//
$mysql_host = "localhost";
$mysql_username = "root";
$mysql_password = "****************";
$mysql_db = "lanman";
$conn = mysql_connect($mysql_host, $mysql_username, $mysql_password) or die("Connection error");
mysql_select_db($mysql_db, $conn);
?>
"Welcome to phpMyAdmin 2.6.2
MySQL 4.1.15-nt running on localhost as root@localhost"
The output whenever connection.php is included:
"Connection Error"
What have I forgotten to do?
Also of note: The connection works fine on the other machine.