Mysql forgot the password solution

xiaoxiao2021-03-06  58

If mysql is running, first kill: killall -term mysqld.

Start mysql: bin / safe_mysqld --skip-grant-Tables &

You can enter mysql without a password.

Then it is> Use mysql> update user set password = password ("new_pass") where user = "root";> flush privilege; re-mysql, start MySQL with normal method.

转载请注明原文地址:https://www.9cbs.com/read-116856.html

New Post(0)