MySQL multi-instance forgot password temporary login

Ss-antlup | GREP 330//Description There are 3306 ports running the database running

TCP LISTEN 0 *:3306 *:* Users: (("mysqld", 7557,12))

Mysql-uroot-p-s/data/3306/mysql.sock//Login not database, password input error

Killall mysqld//Kill msyqld process, can try a few more times

Mysqld_safe--defaults-file=/data/3306/my.cnf--skip-grant-table &//Skip the authorization form directly after a few more carriage returns

Ss-antlup | grep 330
TCP LISTEN 0 *:3306 *:* Users: (("mysqld", 7557,12))

Mysql-uroot-s/data/3306/mysql.sock//Login database, no need to enter the password directly can login

mysql> show databases;

Mysql> select User,host,password from Mysql.user;

Mysql> \q or exit exit the database

This article is from the "12252646" blog, please be sure to keep this source http://12262646.blog.51cto.com/12252646/1947543

MySQL multi-instance forgot password temporary login