Shulou(Shulou.com)06/01 Report--

1) shutdown of mysql5.7:

For mysql installed in rpm mode on centos 7, you must use systemctl stop mysqld.service / service mysqld stop to turn it off

After shutting down with kill-9 or mysqladmin-hlocalhost-P3306-uroot-p shutdown, OS automatically restarts immediately, so you can never shut down the database.

2) mysql5.7 initial password

Mysql5.7 initializes DB. / mysqld-- initialize-- user=mysql-- basedir=/data/mysql/installdir-- datadir=

Directly in the output password, do not generate files. Mysql_secret

2018-03-06T02:32:16.619904Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.

2018-03-06T02:32:16.620566Z 1 [Note] A temporary password is generated for root@localhost: g1hra (pdIsV

3) if two or more mysql are installed on the same machine, it is best to specify-- socket when using a client connection

. / mysql-hlocalhost-P3306-- socket=/u02/mysql57/datadir/3306/data/mysql.sock-uroot-p

Because the first mysql is installed in rpm mode, and the configuration file is under / etc/, when you connect to the second mysql without specifying socket, you may also find the configuration under / etc/ by default, so you can find the socket of the first mysql.

4) Skip password login

. / mysqld_safe-defaults-file=/u02/mysql57/config/my.cnf-skip-grant-tables &

. / mysql-hlocalhost-P3306-- socket=/u02/mysql57/datadir/3306/data/mysql.sock-uroot

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.