Re: mysql problem with socket

2012-04-30 Thread Bjarne D Mathiesen
Ryan Schmidt wrote: A guide for setting up MacPorts MySQL is here: https://trac.macports.org/wiki/howto/MAMP#mysql Hopefully those instructions haven't bitrotted too much. There's also: https://trac.macports.org/wiki/howto/MySQLWorkbench -- Bjarne D Mathiesen København N ; Danmark ;

RE: mysql problem with socket (was Help with conjoined apaches)

2012-04-29 Thread jeff
That link came up non-existent, but I checked the mysql site and found the published solution about checking for the existence of the .sock file and moving it if it's in the wrong place.So, I found that there was mysql.sock in /private/tmp, but the error indicates it's being looked for in

Re: mysql problem with socket (was Help with conjoined apaches)

2012-04-29 Thread Phil Dobbin
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 29/04/2012 18:33, j...@ayendesigns.com wrote: That link came up non-existent [snip] http://dev.mysql.com/doc/refman/5.5/en/connecting-disconnecting.html http://dev.mysql.com/doc/refman/5.5/en/connecting-disconnecting.html; trailing

Re: mysql problem with socket

2012-04-29 Thread Ryan Schmidt
On Apr 29, 2012, at 12:33, j...@ayendesigns.com wrote: That link came up non-existent, but I checked the mysql site and found the published solution about checking for the existence of the .sock file and moving it if it's in the wrong place. So, I found that there was mysql.sock in

RE: mysql problem with socket

2012-04-29 Thread jeff
: Re: mysql problem with socket From: Ryan Schmidt ryandes...@macports.org Date: Sun, April 29, 2012 2:08 pm To: j...@ayendesigns.com Cc: macports-users@lists.macosforge.org On Apr 29, 2012, at 12:33, j...@ayendesigns.com wrote: That link came up non-existent, but I checked the mysql site

RE: mysql problem with socket

2012-04-29 Thread jeff
instances to .old? Original Message Subject: Re: mysql problem with socket From: Ryan Schmidt ryandes...@macports.org Date: Sun, April 29, 2012 3:33 pm To: j...@ayendesigns.com Cc: macports-users@lists.macosforge.org On Apr 29, 2012, at 17:21, j...@ayendesigns.com wrote

Re: mysql problem with socket

2012-04-29 Thread Ryan Schmidt
On Apr 29, 2012, at 17:39, j...@ayendesigns.com wrote: Well, let's back up a second. I installed mysql and mysql-server yesterday, and didn't make any manual changes, so should the my.cnf in the standard ports path (/opt/local/etc) only have 2 entries in it normally? It's normal for

RE: mysql problem with socket

2012-04-29 Thread jeff
Subject: Re: mysql problem with socket From: Ryan Schmidt ryandes...@macports.org Date: Sun, April 29, 2012 3:50 pm To: j...@ayendesigns.com Cc: macports-users@lists.macosforge.org On Apr 29, 2012, at 17:39, j...@ayendesigns.com wrote: Well, let's back up a second. I installed mysql and mysql-server

Re: mysql problem with socket

2012-04-29 Thread Ryan Schmidt
On Apr 29, 2012, at 17:59, j...@ayendesigns.com wrote: I stopped mysql, renamed the other 3 cnf files to cnf.old, and restarted it. It is still using the sock in /private/tmp even though the only cnf file points to /opt/local. I'm at a loss...should I grep for /private/tmp to try and find

RE: mysql problem with socket

2012-04-29 Thread jeff
I had checked with 'find', and /opt/locale/etc/mysql5 is the only my.cnf file. I'm not sure that the mysqld process is port's, only that 'which' shows mysql5 being port's. I start it and stop it via the settings panel. On Apr 29, 2012, at 17:59, j...@ayendesigns.com wrote: I stopped mysql,

Re: mysql problem with socket

2012-04-29 Thread Mr. Puneet Kishor
On Apr 29, 2012, at 6:07 PM, Ryan Schmidt wrote: Are you sure the mysql that's being started is the one MacPorts installed, and not the one you installed in /usr/local? How are you starting / stopping mysql? The above is possibly the commonest mistake, and it is easy to check and

Re: mysql problem with socket

2012-04-29 Thread Ryan Schmidt
On Apr 29, 2012, at 18:22, j...@ayendesigns.com wrote: I had checked with 'find', and /opt/locale/etc/mysql5 is the only my.cnf file. I'm not sure that the mysqld process is port's, only that 'which' shows mysql5 being port's. I start it and stop it via the settings panel. What settings

RE: mysql problem with socket

2012-04-29 Thread jeff
Jeez. No idea. Settings has a MySQL, and, I believe, osx doesn't come with mysql... looking at the other message that just came and will check the process Original Message Subject: Re: mysql problem with socket From: Ryan Schmidt ryandes...@macports.org Date: Sun, April 29

RE: mysql problem with socket

2012-04-29 Thread jeff
'which' shows nothing for mysqld or mysql, but for mysql5 shows /opt/local...ps reveals 2025 ?? 0:00.24 /opt/local/bin/daemondo --label=mysql5 --start-cmd /opt/local/etc/LaunchDaemons/org.macports.mysql5/mysql5.wrapper start ; --stop-cmd

Re: mysql problem with socket

2012-04-29 Thread Mr. Puneet Kishor
Yup, you are running the mysql version *not* installed by MacPorts. If you look below, you are running `/usr/local/mysql/bin/mysqld` which either you knowingly installed, or was installed by some other program without you realizing. The reason `which mysqld` shows nothing is because

Re: mysql problem with socket

2012-04-29 Thread Jeff Greenberg
I'll edit $PATH. What is the proper way to start it? Sent from my iPhone On Apr 29, 2012, at 7:50 PM, Mr. Puneet Kishor punk.k...@gmail.com wrote: Yup, you are running the mysql version *not* installed by MacPorts. If you look below, you are running `/usr/local/mysql/bin/mysqld` which either

Re: mysql problem with socket

2012-04-29 Thread Mr. Puneet Kishor
On Apr 29, 2012, at 7:47 PM, j...@ayendesigns.com wrote: There is no mysqld in that directory ... there are mysqld_multi and mysqld_safe, but with that path added to $PATH 'which' still comes up empty Ah... well, mysqld_safe is just a safe version of starting the mysql daemon. So,

Re: mysql problem with socket

2012-04-29 Thread Ryan Schmidt
On Apr 29, 2012, at 19:57, Mr. Puneet Kishor wrote: On Apr 29, 2012, at 7:47 PM, j...@ayendesigns.com wrote: There is no mysqld in that directory ... there are mysqld_multi and mysqld_safe, but with that path added to $PATH 'which' still comes up empty Ah... well, mysqld_safe