Need help connecting PHP and mySQL

The Alchemist's Avatar, Join Date: Jul 2012
Go4Expert Member
Hello everyone..
I'm trying to connect to my mySQL database named mydb using PHP.
The hosting site where I've created my database says : Server: "Localhost via UNIX socket"
So, if I connect with mysql_connect($hostname,$user,$password);
What will be the value of $hostname? will it be $hostname='localhost:9000' or 'localhost' or what should I put?
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
The host should be your host's IP address or hostname. It can be localhost if your PHP and MySQL are on the same server of your host.
The Alchemist like this
The Alchemist's Avatar, Join Date: Jul 2012
Go4Expert Member
I think its localhost... Thanks for helping.
hanleyhansen's Avatar, Join Date: Jan 2008
Pro contributor
I recommend using PHP's PDO or mysqli instead of mysql_connect as mysql_connect won't be supported for long and the community has already begun the deprecation process.
The Alchemist's Avatar, Join Date: Jul 2012
Go4Expert Member
Thanks for the suggestion guys... I realised that its normally given on the hosting sites... Anyways, thanks for helping...