[MacPorts] #20421: mysql5-server port failed to start

[MacPorts]

#20421: mysql5-server port failed to start
--------------------------------+-------------------------------------------
 Reporter:  conradwt@…          |       Owner:  ryandesign@…           
     Type:  defect              |      Status:  new                    
 Priority:  Normal              |   Milestone:                         
Component:  ports               |     Version:  1.8.0                  
 Keywords:                      |        Port:  mysql5-server          
--------------------------------+-------------------------------------------

Comment(by jfjhong@…):

 Replying to [ticket:20421 conradwt@…]:
 > The mysql5-server port failed to be accessing after executing the
 following commands on Snow Leopard build 10A411:
 >
 >   - sudo launchctl load -w
 /Library/LaunchDaemons/org.macports.mysql5.plist
 >   - sudo -u mysql mysql_install_db5
 >   - reboot
 >   - mysql5 -u root
 >
 > {{{
 > ERROR 2002 (HY000): Can't connect to local MySQL server through socket
 '/opt/local/var/run/mysql5/mysqld.sock' (2)
 > }}}
 >
 > Is there a missing step somewhere?

 I had the same exact error when I tried to start MySQL server on my
 macbook pro running SL. Eventually i found the solution. It seems like
 there MySQL is looking for the socket connection in the wrong place.  Go
 to /opt/local/etc/php5/php.ini-development and make sure that the
 following variables are blank

 pdo_mysql.default_socket

 mysql.default_socket

 mysqli.default_socket =

 in my case they were set to /tmp/mysql.sock . Also if you have a  .cnf
 file make sure you are not pointing the defeault socket to the wrong
 location

-- 
Ticket URL: <http://trac.macports.org/ticket/20421#comment:21>
MacPorts <http://www.macports.org/>
Ports system for Mac OS