First Timer

[artizan]

Hi peeps, I’m new to this forum, and to PHP and Mysql so I’m just seeking a bit of info..

When using Mysql_connect I’m having problems connecting to my database. Am I right in saying that if I’m just using the software locally, username is root, password is blah and the table I’m trying to access is called account the script would look something like this

$dbHost = "localhost";
$dbUser = "root";
$dbPass = "blah";
$dbDatabase = "account";

$db = Mysql_connect("$dbHost", "$dbUser", "$dbPass");

if this is right, is there I way I can echo back that its been successful?
Also in Mysql how can you see what the username and password are for that database, so i can access it from this php script, if you see what I mean…..

Thanks for ya help people, and anyone that can recommend a good book, would also be a great help.. I have a bad habit of always picking up lame books…

[lanjoky]

try leaving username and password blank and see if that works ... depends on how you have ur system setup but unless you changed the config ... the default is both blank I believe ... Let me know if that doesnt work and I will try again 🙂

GL

[laserlight]

One way, with your given variables, is:

$db = mysql_connect($dbHost, $dbUser, $dbPass)
	OR die("Error: could not connect due to - " . mysql_error());
mysql_select_db($dbDatabase, $db)
	OR die("Error: could not select database!");