Results 1 to 2 of 2

Thread: Info about mysqld_safe, when to use?

  1. #1
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,306
    Blog Entries
    2

    Default Info about mysqld_safe, when to use?

    Looking for more information and possibly scenarios where the alternative mysqld/mariadb startup script mysqld_safe might be used.

    I became aware of this alternative way to startup only within the last day by reports about a significant vulnerability and patch related to this script (cve-2016-6662) which is so new that the incident number is currently reserved but is not yet described in the official database (as of this writing) so can only be researched based in bug reports and patches (and of course various public comment).

    Based on descriptions I've read on possible attack vectors, I <don't> think that any existing openSUSE MySQL/MariaDB install is vulnerable by default although as of today my current TW and LEAP mariadb apps don't have the patch.

    It seems that this is a possibly recommended way to start the mysql/mariadb daemon with certain settings like auto recovery or "can't kill," enhanced logging, more
    http://dev.mysql.com/doc/refman/5.7/en/mysqld-safe.html

    It also looks(to me) like our current default MariaDB installs do <not> implement this script, the mysql daemon is started up the "vanilla" way by systemd

    But, if there are any experienced MySQL Admins out there who have used this script, am interested in what situations you've done so.

    TIA,
    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  2. #2
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,450

    Default Re: Info about mysqld_safe, when to use?

    Some extracts from the MariaDB manual:
    mysqld_safe is the recommended way to start a mysqld server on Unix ... mysqld_safe adds some safety features such as restarting the server when an error occurs and logging runtime information to an error log file.
    mysqld_safe tries to start an executable named mysqld.
    Many of the options to mysqld_safe are the same as the options to mysqld.
    mysqld_safe reads all options from the [mysqld], [server], and [mysqld_safe] sections in option files.
    The mysql.server script starts mysqld by first changing to the MariaDB install directory and then calling mysqld_safe.
    If you have installed MariaDB to a non-standard location, you may need to edit the mysql.server script to get it to work right.


    It was introduced in 5.0.4; so The manual lists a series of options that can be passed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •