[MySQL] Install difficulties : Can't connect to local MySQL server through

[markd at macports.org]

I confess I haven't been follwing this thread as closely as I could have,
but I really don't understand what the problem is.  I have several howtos
on the net that use mysql5 and the instructions are quite short, simple,
and work fine by all accounts.  I've never thought much about what the
file hierarchy is, and I don't see why anyone would care.

http://homepage.mac.com/duling/halfdozen/NeDi-Howto.html#d0e94

However, I do think that having a +server variant is pointless and adds
needless hassle, and probably the result of a paranoid standpoint on
security.  As soon as 1.5 comes out the startupitem is disabled by default
(as my instructions assume, and as it was supposed to be from the start),
and I really think enough grief and confusion has been encountered over
this that it really should be terminated with extreme prejudice.  I think
those arguing for keeping the server variant should list the reasons and
let us debate them point-by-point.  And I'm going to frown on "because
someone will commit a mysql5-server port any time now anyway" because that
one's a bit old by now.

Mark


Bill Hernandez <ms at mac-specialist.com> on Monday, June 25, 2007 at 2:55 PM
-0800 wrote:
>The reason for using MacPorts in the first place is to simplify the  
>whole unix thing, with that in mind, why over-complicate the hierarchy.
>
>I screwed around with the MacPorts version of MySQL for about a week  
>off and on, and couldn't get it running...
>
>NOTE : While I was waiting for a reply to this problem I downloaded  
>the MySQL for OSX from http://www.MySQL.com, followed the simple  
>instructions and got it running in about 20 minutes, and within a  
>brief time after that I had imported all my data. They use a simple  
>hierarchy that works with simple instructions. I even ran the secure  
>install using :
>
>$ /usr/local/mysql/bin/mysql_secure_installation
>
>and it all worked the first time...
>
>For some reason, MacPorts uses an OVER-COMPLICATED HIERARCHY for  
>MySQL, yet it uses a simple and great hierarchy for APACHE2.
>You can go to the MacPorts Apache2 folder and find everything you  
>could possibly need all in one place.
>
>The shame is that these guys that volunteer to do all this work are  
>spending a great deal of time and effort to do all this, and I almost  
>feel like a terrible ingrate for mentioning the fact that the user  
>experience is probably now what they intended...