Article:		Web Apps with Tiger: Security and MySQL
Subject:		Can't connect to local MySQL server through socket
Date:		2005-11-24 13:03:51
From:		anne001
I have the latest Tiger installed. 10.4.3 I followed the instructions in the tutorial (4.1.15) but mysql_secure_installation gives an error Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) and it returns to asking for a password. the various emails talk about a file my.cnf and setting a path.

Showing messages 1 through 4 of 4.

• Can't connect to local MySQL server through socket
  2005-11-25 05:05:17  anne001 [View]
  
  
  http://docs.info.apple.com/article.html?artnum=301457
  solution 1 did not work for me.
  solution 2 did not work for me, even with
  sudo apachectl restart to get the changes in php.ini to take.
  and there is no /var/mysql folder.
  
• Can't connect to local MySQL server through socket
  2005-11-25 05:11:16  Kevin Hemenway | [View]
  
  
  Are you sure the MySQL server is actually started? Check the MySQL System Preference that was installed - if the server isn't started, then you'll receive this error message.
• Can't connect to local MySQL server through socket
  2005-11-26 08:33:35  anne001 [View]
  
  
  This is strange. This morning it works. Turning off the computer and rebooting fixed something!
• Can't connect to local MySQL server through socket
  2005-11-26 13:25:39  Kevin Hemenway | [View]
  
  
  Yes, since you probably installed the MySQL Startup item, per my instructions, when you rebooted your machine, MySQL started up with everything else. The error before was because MySQL was not actually started per the System Preference.