How to start and stop mysql?

[Kevin O'Gorman]

On Fri, Jan 12, 2018 at 9:09 AM, Volker Wysk <post at volker-wysk.de> wrote:

> Am Freitag, 12. Januar 2018, 08:46:21 CET schrieb Kevin O'Gorman:
> > On Fri, Jan 12, 2018 at 7:22 AM, Volker Wysk <post at volker-wysk.de>
> wrote:
> >
> > > Am Freitag, 12. Januar 2018, 09:08:22 CET schrieb Wade Smart:
> > > > On Fri, Jan 12, 2018 at 9:03 AM, Kevin O'Gorman <kogorman at gmail.com>
> > > wrote:
> > > >
> > > > > I need to start and stop mysql, and I've only figured out how to
> stop
> > > it.
> > > > > I need to start it (not rebooting) so that I can temporarily use
> > > different
> > > > > options.  In my case, I need --skip-grant-tables.
> > >
> > > > sudo service mysql start
> > >
> > > This just starts mysql the normal way. But the OP said, that he needs
> to
> > > start it temporarily with self specified options.
> > >
> > > The following is how mysql is normally started (this is taken from
> > > /etc/init.d/mysql):
> > >
> > >             # Start MySQL!
> > >             su - mysql -s /bin/sh -c "/usr/bin/mysqld_safe > /dev/null
> > > 2>&1 &"
> > >
> > > So the OP could use this, modify it as needed.
> > >
> > > Cheers
> > > Volker
> > >
> > >
> > Thanks.  Useful, I hope, but SHEESH! that mysqld_safe is over 1,000 lines
> > of code.  I'll figure out how to use and modify it somehow....
>
> Good luck
>
> Volker
>
>
Thanks, but even copying that command line does not work:
  su - mysql -s /bin/sh -c "/usr/bin/mysqld_safe > /dev/null  2>&1 &"
  No directory, logging in with HOME=/

And mysql itself reports
  ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/run/mysqld/mysqld.sock' (2)

But 'service mysql start' works okay.   I'll have to figure out how it does
that.  Or just temporarily edit mysqld_safe.


-- 
Kevin O'Gorman
#define QUESTION ((bb) || (!bb))   /* Shakespeare */

Please consider the environment before printing this email.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20180112/e63194cc/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 441 bytes
Desc: not available
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20180112/e63194cc/attachment.gif>