MySQL Boot related knowledge

The difference between starting with mysqld and Mysqld_safe

The method of running the MYSQLD program directly to start the MySQL service is rarely seen,mysqld_safe script "Note: Mysqld_safe is just a script" will continue to monitor its operation after starting the MySQL server and restart it when it dies. The practice of starting a MySQL server with a mysqld_safe script is common on BSD-style UNIX systems, and Mysql.server scripts in non-BSD-style UNIX systems actually invoke the Mysqld_safe script to start the MySQL server. It usually does the following things:
1. Check the system and options.
2. Check the MyISAM table.
3. Keep the MySQL server window.
4. Start and monitor the mysqld and restart if the error terminates.
5. Send the MYSQLD error message to the Host_name.err file in the data directory.
6. Send the Mysqld_safe screen output to the Host_name.safe file in the data directory.

How to Mysqld_safe daemon processes

/usr/local/mysql/bin/mysqld_safe &

then enter and exit.

Locate MY.CNF View all the configuration file locations in the system

Mysqd_safe The default use of/etc/my.cnf or./my.cnf I'm not quite sure, I'll add it later.

MySQL Boot related knowledge