![]() Users with shutdown_priv='Y' can only be done from mysqladmin. Users with this privilege cannot issue a shutdown from the mysql client. This evidently would permit a user who connects to mysqladmin to issue a shutdown. GRANT ALL PRIVILEGES ON *.* TO IDENTIFIED BY 'whateverpassword' ĬAVEAT If you do DESC er, you will see that one of the privilege columns is Shutdown_priv. Run these lines to create that user: SET SQL_LOG_BIN=0 ![]() I usually connect using TCP/IP /usr/local/mysql/bin/mysqladmin -u root -h127.0.0.1 -p shutdownÄoing it this way bypasses checking for a socket file. Such a standard shutdown would just hang. Whenever the socket file disappears, the mysqld_safe program cannot shutdown without first seeing in the socket file. Instead, we can run the mysqldsafe script, which starts mysqld, and constantly checks if it is active.If mysqld crashes, mysqldsafe tries to restart it. However, this is not the recommended way to start MariaDB on Linux/UNIX systems. ![]() The standard way to shutdown mysql in Linux is service mysql stop. This command starts a MariaDB demon, the programs which will remain active and waiting for client connections. In Linux, I have seen the mysql.sock (the socket file) file just up and disappear without warning. I actually prefer your mysqladmin method for a reason. This shutdown method can be done in MacOS, Linux, Windows, any platform MySQL is supported in.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |