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?
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.
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.
Thanks for the suggestion guys... I realised that its normally given on the hosting sites... Anyways, thanks for helping...