Web lists-archives.com

Re: a curse on OS sierra and MySQL?

Well, the command

sudo /usr/local/mysql/support-files/mysql.server stop 

generates the error message:

ERROR! MySQL server PID file could not be found!

On the other hand, 

sudo launchctl unload -F /Library/LaunchDaemons/com.oracle.oss.mysql.mysqld.plist

stops the server and 

sudo /usr/local/mysql/support-files/mysql.server start

starts it

On 12/3/16, 4:40 PM, "Peter Brawley" <peter.brawley@xxxxxxxxxxxxx> wrote:

    On 12/3/2016 13:58, Martin Mueller wrote:
    > I was able to install a version of MySQL 5.6 on OS Sierra. It appears that the “launchdaemon’ method works while the mysql.server start/stop method does not work.  In retrospect I should have seen that, but I also think that the official documentation could and should be more explicit about what is a significant change in Apple’s start/stop routines.
    If you mean that seriously, it needs to be more specific.
    > On 12/3/16, 12:43 PM, "Peter Brawley" <peter.brawley@xxxxxxxxxxxxx> wrote:
    >      On 12/2/2016 17:58, Martin Mueller wrote:
    >      > Alas, running the stop and start commands under sudo makes zero difference.
    >      ?! The cited page recommends more than sudo starts and stops, eg ...
    >      |unset TMPDIR mysql_install_db |
    >      Did you try that? Did you check the pid setting in my.cnf, eg
    >      pid-file=/var/run/mysqld/mysqld.pid? I believe you need to ensure that
    >      the pid file specified in my.cnf exists and that the mysql daemon owns
    >      it ...
    >      mkdir /var/run/mysqld
    >      touch /var/run/mysqld/mysqld.pid
    >      chown -R mysql:mysql /var/run/mysqld
    >      Also see
    >      https://urldefense.proofpoint.com/v2/url?u=http-3A__superuser.com_questions_159486_how-2Dto-2Dkill-2Dprocess-2Din-2Dmac-2Dos-2Dx-2Dand-2Dnot-2Dhave-2Dit-2Drestart-2Don-2Dits-2Down&d=CwIDaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk&m=Rp61bfD4ngoSU50qebNy37Nmv34OSqdiU4Sigj8b9zI&s=RDN0din-b9O7hEkNJOKe1CbYe_5MipeeuN2oeOMsWfI&e=
    >      > This is a very frustrating problem, and I hope somebody in the MySQl documentation department will take a look at it. It’s  cleary a problem that has been around for years because the Web is full of complaints and tips. But there doesn’t seem to be any convergence a bout a diagnosis or a likely cure. And there is nothing in the MySQL documentation that draws attention to the probem.
    >      >
    >      > In my case, I’m double frustrated because some months ago my MySQL application broke around this problem, and then a couple of weeks ago it cured itself when I somewhat arbitrarily picked up an earlier version of my installation from Time Machine.
    >      That suggests the problem arose from a change in your app, or a setting
    >      change that occurred in a MySQL upgrade. To show that this is a common
    >      problem that MySQL docs ought to address, you'll need to identify the
    >      setting that's gone awry.
    >      PB
    MySQL General Mailing List
    For list archives: https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.mysql.com_mysql&d=CwIDaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk&m=I5PKsknY5e1wjZZG11zhg1tGbZKrqgs0FExanPNtMkk&s=40lzUebvOmuxTUq-dnXHbwXgaFEyIyYqf93pjPGQibU&e= 
    To unsubscribe:    https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.mysql.com_mysql&d=CwIDaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk&m=I5PKsknY5e1wjZZG11zhg1tGbZKrqgs0FExanPNtMkk&s=40lzUebvOmuxTUq-dnXHbwXgaFEyIyYqf93pjPGQibU&e= 

MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql