g0itp1 Posted April 12, 2006 Share Posted April 12, 2006 Hi,I hope you can help, I've been struggling for some time now, the problem is, PHP reports it can't connect to the mysql database viia /tmp/mysql. However the socket for the database is /var/run/mysqld/mysqld.sock.Mysql report this as correct, the my.cnf file has the correct socket, but the php is apparently trying to connect via the default socket?can anyone point me in the right direction, is it a global setting that is overriding?the system is Deebian, MySql 5, PHP4, Apache 2Thanks Link to comment https://forums.phpfreaks.com/topic/7249-php-wrong-mysql-socket/ Share on other sites More sharing options...
craygo Posted April 12, 2006 Share Posted April 12, 2006 if you are not connecting to default socket then you can manually enter it in your connection string with the host name.[code]$host = "127.0.0.1:3307";$user = "someuser";$password = "somepassword";$dbname = "somedatabase";$mysql_conn = mysql_connect($host, $user, $password);mysql_select_db($dbname, $mysql_conn) or die(mysql_error());[/code]Ray Link to comment https://forums.phpfreaks.com/topic/7249-php-wrong-mysql-socket/#findComment-26379 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.