Web lists-archives.com

Re: a curse on OS sierra and MySQL?




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.

PB

-----


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: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql