How to start and stop mysql?

[Colin Law]

On 12 January 2018 at 16:46, Kevin O'Gorman <kogorman at gmail.com> wrote:

>
>
> 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....
>

I believe you should be able to pass the option to mysqld_safe and it will
be passed to mysqld
https://dev.mysql.com/doc/refman/5.7/en/mysqld-safe.html

Colin


>
>
> --
> Kevin O'Gorman
> #define QUESTION ((bb) || (!bb))   /* Shakespeare */
>
> Please consider the environment before printing this email.
>
> --
> ubuntu-users mailing list
> ubuntu-users at lists.ubuntu.com
> Modify settings or unsubscribe at: https://lists.ubuntu.com/
> mailman/listinfo/ubuntu-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-users/attachments/20180112/62f53397/attachment.html>