![\"\"](\"\/wordpress\/wp-content\/uploads\/2011\/12\/computer_problem-150x150.jpg\" "\\"Computer")
<\/p>\n<\/p>\n
\nWhen I tried to connect to the MySQL server through PHP, I got the following error: Can’t connect to local MySQL server through socket ‘\/var\/lib\/mysql\/mysql.sock’ (2)<\/strong>\n<\/p>\n \nTo give you some background, here is my situation. My Fedora Linux is a 64-bit machine, and I have installed a 32-bit version of XAMPP (i.e., 32-bit PHP, 32-bit MySQL) for the web server. Also, I have some PHP scripts that will be run in background. These scripts are run using 64-bit PHP. Both 32-bit and 64-bit PHP need to access the MySQL database. Long story short. I got the MySQL error message when I tried to execute using the 64-bit PHP, while the 32-bit PHP has no complain.\n<\/p>\n When PHP talks to MySQL, it needs to talk to the MySQL representative, i.e., mysql.sock<\/strong>. If it cannot talk to the mysql.sock, then PHP will be unable to access the MySQL database.<\/p>\n The reason why my 64-bit PHP could not talk to MySQL because of a wrong location of mysql.sock. To solve this problem, simply do the following:<\/p>\n First, let’s find out where is the PHP.ini of the 64-bit PHP:<\/p>\n In Fedora Linux, it is:<\/p>\n Then, we need to find out where is the mysql.sock:<\/p>\n In my case, it is:<\/p>\n Now, let’s tell PHP the location of the mysql.sock:<\/p>\n And change the following line from:<\/p>\n to:<\/p>\n Now, try to run your script again. The problem should be gone.<\/p>\n Have fun with MySQL.<\/p>\n –Derrick<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":"<\/div>\n\r\nsudo find \/ -name \"php.ini\"\r\n<\/pre>\n
\r\n\/etc\/php.ini\r\n<\/pre>\n
\r\nsudo find \/ -name \"mysql.sock\"\r\n<\/pre>\n
\r\n\/opt\/lampp\/var\/mysql\/mysql.sock\r\n<\/pre>\n
\r\nsudo nano \/etc\/php.ini\r\n<\/pre>\n
\r\nmysql.default_socket =\r\n<\/pre>\n
\r\nmysql.default_socket = \/opt\/lampp\/var\/mysql\/mysql.sock\r\n<\/pre>\n