[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 [comment:21 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

 I forgot to mention....
 after following the previous steps, try using:

   /opt/local/share/mysql5/mysql/mysql.server start

 it should succeed :)
 to double check try mysqlshow5 -p to see the databases installed in your
 machine

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