一、以安全模式登錄

# Stop MySQL sudo service mysql stop# Make MySQL service directory. sudo mkdir -p /var/run/mysqld# Give MySQL user permission to write to the service directory. sudo chown mysql:mysql /var/run/mysqld# Start MySQL manually, without permission checks or networking. sudo mysqld_safe --skip-grant-tables &# Log in without a password. mysql -u root

二、修改密碼

UPDATE mysql.user SET authentication_string=PASSWORD('NEW-PASSWORD'), plugin='mysql_native_password' WHERE User='root' ; EXIT;

三、重啟數(shù)據(jù)庫

# Turn off MySQL. sudo mysqladmin -S /var/run/mysqld/mysqld.sock shutdown# Start the MySQL service normally. sudo service mysql start

轉(zhuǎn)載于:https://www.cnblogs.com/kelsen/p/10858351.html

總結(jié)

以上是生活随笔為你收集整理的MySql 5.7 重置root密码的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。