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 Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.