Need help connecting PHP and mySQL

Go4Expert Member
8Jul2012,13:45   #1
The Alchemist's Avatar
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?
Go4Expert Founder
8Jul2012,13:58   #2
shabbir's Avatar
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
Go4Expert Member
8Jul2012,18:28   #3
The Alchemist's Avatar
I think its localhost... Thanks for helping.
Pro contributor
31Jul2012,01:32   #4
hanleyhansen's Avatar
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.
Go4Expert Member
16Aug2012,11:35   #5
The Alchemist's Avatar
Thanks for the suggestion guys... I realised that its normally given on the hosting sites... Anyways, thanks for helping...