how to connect to the mysql database

[mpaev]

im trying a simple database tutorial, and i can't make contact to the database, I get this warning:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) in /Applications/xampp/xamppfiles/htdocs/test/- on line 22 Could not connect to database

my database.php is in /Applications/xampp/xamppfiles/htdocs/test/

and the php script connecting to the database is:

// Connect to MySQL
if ( !( $database = mysql_connect( "localhost",
"httpd", "" ) ) )
die( "Could not connect to database" );

// open Products database
if ( !mysql_select_db( "Products", $database ) )
die( "Could not open Products database" );


what am I doing wrong :S

[Wiedmann]

You have an user "httpd" (with no password) in MySQL?

[mpaev]

ehm, im sorry im a bit of a noob on database.

I not sure what your refering to.? :S

[Wiedmann]

I not sure what your refering to.? :S

Well:

Code: Select all

if ( !( $database = mysql_connect( "localhost", "httpd", "" ) ) )

In this function you want connect to a MySQL server at "localhost" with the user "httpd" and no password "".
--> So I ask you. You have this user in MySQL?

ehm, im sorry im a bit of a noob on database.

And of course PHP...

im trying a simple database tutorial,

BTW: It's allways a good idea to read the PHP (MySQL) manual and trying out the examples there.