How to start and stop mysql?

[Kevin O'Gorman]

On Fri, Jan 12, 2018 at 10:27 AM, Kevin O'Gorman <kogorman at gmail.com> wrote:

>
>
> 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.
>
>
>
>
I seem to have solved my own problem.  Some of the stuff that's present and
looks germane is actually ignored,
because the code is generic and is designed to work with systems with and
without systemd.  The stuff I needed
was in /etc/mysql/mysql.conf/

In particular mysqld.cnf in that directory looks sort of like a script, but
is turned into command-line parameters.
I added mine there, and was able to turn off passwords for a bit, and do
the cleanup by following instructions
in https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html

Now I have a working root password again.

-- 
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/01a4d7c9/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/01a4d7c9/attachment.gif>