daws qhov yuam kev 1045 (28000): Kev nkag tsis tau rau tus neeg siv 'root'@'localhost' (siv tus password: YOG)

sivLinuxhost yuavVestaCPvaj huam sib luagMySQL databaseHloov kho mus rau Mariadb version 10.4.6.

Tsis xav txog, nkag mus rau cov lus txib nram qab no ▼

mysql -uroot -p

• Sau tus password kom nkag musmysql.

Qhov yuam kev hauv qab no tshwm sim ▼

YUS 1045 (28000): Kev nkag tsis tau rau tus neeg siv 'root'@'localhost' (siv tus password: YOG)

Feem ntau qhov kev ua yuam kev no yog tshwm sim los ntawm kev tsis ncaj ncees lawm hauv paus tus neeg siv lo lus zais rau MySQL cov ntaub ntawv, qhov kev daws teeb meem yog qhov tseeb los rov pib dua tus password.

Yuav ua li cas rau MySQL ERROR 1045 (28000) yuam kev?

Kauj Ruam 1:siv SSHSoftwareTom qab nkag rau hauv, nkag mus rau cov lus txib hauv qab no kom nres mysql database ▼

systemctl stop mysqld

Kauj Ruam 2:Pib MySQL nrog cov lus txib hauv qab no thiab pib nws yam tsis tau kuaj xyuas kev tso cai ▼

mysqld --skip-grant-tables &

Lub sijhawm no, lwm qhov yuam kev tau tshaj tawm ▼

[ERROR] yuam kev tuag: Thov nyeem "Kev Nyab Xeeb" ntu ntawm phau ntawv qhia kom paub yuav ua li cas khiav mysqld li hauv paus!

Thov SSH thiab sau cov lus txib nram qab no ▼

mysqld --user=root --skip-grant-tables &

Kauj Ruam 3:SSH nkag mus rau mysql ▼

mysql -uroot

los yog

mysql

Kauj Ruam 4:hloov root password

Mysql5.7 lossis tom qab ▼

UPDATE mysql.user SET Password=PASSWORD('123456') where USER='root';

Mysql5.7 version ▼

UPDATE mysql.user SET authentication_string=PASSWORD('123456') where USER='root';

Kauj Ruam 5:Refresh permissions ▼

flush privileges;

Kauj Ruam 6:tawm mysql ▼ 

exit

los yog

quit

Kauj Ruam 7:Rov nkag mus rau mysql nrog tus neeg siv hauv paus ▼

Mysql -uroot -p

• Sau tus password:<输入刚改好的密码123456>