[MacPorts] #24956: Having trouble installing mysql

[MacPorts]

#24956: Having trouble installing mysql
--------------------------+-------------------------------------------------
 Reporter:  samii@…       |       Owner:  macports-tickets@…                   
     Type:  defect        |      Status:  new                                  
 Priority:  Normal        |   Milestone:                                       
Component:  wiki          |     Version:                                       
 Keywords:                |        Port:  php5                                 
--------------------------+-------------------------------------------------
Changes (by ryandesign@…):

 * cc: ryandesign@… (added)


Old description:

> Hi:
>
> I have started the process of installing MAMP as per the instructions on
> the MacPorts wiki howto for MAMP on
> http://trac.macports.org/wiki/howto/MAMP
>
> I had no problems through the beginning of Step 3: Install MySQL. The
> port install worked seamlessly.
>
> However, setting up the database was very silent (no feedback what so
> ever).
>
> The autostart seems to work, and grep filtering for mysql processes seems
> to indicate mysql is running no problem.
>
> But when I try to set the root password, I get the following error.
>
> mysqladmin5: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket
> '/opt/local/var/run/mysql5/mysqld.sock' (2)'
> Check that mysqld is running and that the socket:
> '/opt/local/var/run/mysql5/mysqld.sock' exists!
>
> Likewise, when I try to log into the server, it says:
>
> Can't connect to local MySQL server through socket
> '/opt/local/var/run/mysql5/mysqld.sock' (2)
>
> I am running Mac OS X 10.6.3
> 2.4 GHz Intel Core 2 Duo
> 3 GB Ram
>
> Not sure how to proceed.

New description:

 Hi:

 I have started the process of installing MAMP as per the instructions on
 the MacPorts wiki howto for MAMP on [wiki:howto/MAMP howto/MAMP]

 I had no problems through the beginning of Step 3: Install MySQL. The port
 install worked seamlessly.

 However, setting up the database was very silent (no feedback what so
 ever).

 The autostart seems to work, and grep filtering for mysql processes seems
 to indicate mysql is running no problem.

 But when I try to set the root password, I get the following error.

 {{{
 mysqladmin5: connect to server at 'localhost' failed
 error: 'Can't connect to local MySQL server through socket
 '/opt/local/var/run/mysql5/mysqld.sock' (2)'
 Check that mysqld is running and that the socket:
 '/opt/local/var/run/mysql5/mysqld.sock' exists!
 }}}

 Likewise, when I try to log into the server, it says:

 {{{
 Can't connect to local MySQL server through socket
 '/opt/local/var/run/mysql5/mysqld.sock' (2)
 }}}

 I am running Mac OS X 10.6.3 [[br]]
 2.4 GHz Intel Core 2 Duo [[br]]
 3 GB Ram

 Not sure how to proceed.

--

Comment:

 Then that's a separate issue.

 Have you added this line to your httpd.conf and restarted Apache?
 {{{
 Include conf/extra/mod_php.conf
 }}}

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