Re: [MySQL] Install difficulties : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2007-06-25 Thread Bill Hernandez
Paul, This is a copy of the message I sent Ryan Schmidt. 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

Re: [MySQL] Install difficulties : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2007-06-24 Thread Ryan Schmidt
On Jun 25, 2007, at 00:02, Bill Hernandez wrote: On Jun 24, 2007, at 11:21 PM, Ryan Schmidt wrote: I'm going to snip right there because you've written such a voluminous message that I'm having immense difficulties taking it all in. But as has been pointed out, /tmp/mysql.sock is not where

Re: [MySQL] Install difficulties : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2007-06-24 Thread Bill Hernandez
On Jun 24, 2007, at 11:21 PM, Ryan Schmidt wrote: I'm going to snip right there because you've written such a voluminous message that I'm having immense difficulties taking it all in. But as has been pointed out, /tmp/mysql.sock is not where the MacPorts mysql5 puts its socket. (/tmp/mysql

Re: [MySQL] Install difficulties : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2007-06-24 Thread Chris Pickel
On 25 Jun, 2007, at 00:21, Ryan Schmidt wrote: On Jun 24, 2007, at 22:12, Chris Pickel wrote: The two files which you need be most concerned about are: 1. /opt/local/etc/my.cnf Actually I use /opt/local/etc/mysql5/my.cnf By George, you're right! My mysql server was still listening on :3306

Re: [MySQL] Install difficulties : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2007-06-24 Thread Ryan Schmidt
On Jun 24, 2007, at 22:12, Chris Pickel wrote: The two files which you need be most concerned about are: 1. /opt/local/etc/my.cnf Actually I use /opt/local/etc/mysql5/my.cnf This file is not provided by default by mysql5. Have a look at the sample my.cnf files in /opt/local/share/mysql5/my

Re: [MySQL] Install difficulties : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2007-06-24 Thread Ryan Schmidt
On Jun 24, 2007, at 17:08, Bill Hernandez wrote: I seemed to have gotten mySQL installed and running, but after a couple o start/stop events, now I am getting : ERROR : Connection Failed : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) and after a couple of day

Re: [MySQL] Install difficulties : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2007-06-24 Thread Ryan Schmidt
On Jun 24, 2007, at 18:46, paul beard wrote: On Jun 24, 2007, at 3:33 PM, paul beard wrote: You might want to look in the archives to see where the socket lives in a sandbox like MacPorts: I don't think it lives in /tmp. The socket is here [ /opt/local/var/run/mysql5/mysqld.sock ] Correct

Re: [MySQL] Install difficulties : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2007-06-24 Thread Chris Pickel
Bill, The two files which you need be most concerned about are: 1. /opt/local/etc/my.cnf This file is not provided by default by mysql5. Have a look at the sample my.cnf files in /opt/local/share/mysql5/mysql/ and pick one according to your liking (mine, for example, is my-small.cnf with

Re: [MySQL] Install difficulties : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2007-06-24 Thread paul beard
On Jun 24, 2007, at 3:33 PM, paul beard wrote: You might want to look in the archives to see where the socket lives in a sandbox like MacPorts: I don't think it lives in /tmp. The socket is here [ /opt/local/var/run/mysql5/mysqld.sock ] I can't get it working either ;-) I'm installing the wh

Re: [MySQL] Install difficulties : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2007-06-24 Thread paul beard
On Jun 24, 2007, at 3:08 PM, Bill Hernandez wrote: ERROR : Connection Failed : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) your note reminded me that I needed to install this too: this might be helpful: error: 'Can't connect to local MySQL server through sock

Re: [MySQL] Install difficulties : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2007-06-24 Thread paul beard
On 6/24/07, Bill Hernandez <[EMAIL PROTECTED]> wrote: I seemed to have gotten mySQL installed and running, but after a couple o start/stop events, You might want to look in the archives to see where the socket lives in a sandbox like MacPorts: I don't think it lives in /tmp. -- Paul Beard /

[MySQL] Install difficulties : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2007-06-24 Thread Bill Hernandez
I seemed to have gotten mySQL installed and running, but after a couple o start/stop events, now I am getting : ERROR : Connection Failed : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) and after a couple of days trying to solve this problem decided to seek wis