Re: mysql problem with socket

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

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, m

Re: mysql problem with socket

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

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 The reason `which mysqld` shows nothing is because /opt/local/lib/mysql5/bin is not in your path. ___ mac

Re: mysql problem with socket

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" 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 you > knowingl

Re: mysql problem with socket

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 /opt/local/l

RE: mysql problem with socket

'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 /opt/local/etc/LaunchDaemons/org.macports.mysql5/mys

RE: mysql problem with socket

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: Su

Re: mysql problem with socket

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

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 corre

RE: mysql problem with socket

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, ren

Re: mysql problem with socket

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 f

RE: mysql problem with socket

al Message 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 installe

Re: mysql problem with socket

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 /opt/

RE: mysql problem with socket

the other 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...@ayend

Re: mysql problem with socket

On Apr 29, 2012, at 17:21, j...@ayendesigns.com wrote: > That would be a nice easy fix, to undo a change I made to my.cnf :-) but in > looking at the two lines in /opt/local/etc/mysql5/my.cnf (2 lines?! is there > another and that's the problem?) There are many locations where mysql will look

RE: mysql problem with socket

bject: 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

Re: mysql problem with socket

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 (was Help with conjoined apaches)

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 29/04/2012 18:33, j...@ayendesigns.com wrote: > That link came up non-existent [snip] > > > > >; trail

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

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 /opt/loca