Magance ERROR 1045 (28000): An hana samun dama ga mai amfani 'tushen'@'localhost' (ta amfani da kalmar sirri: YES)

amfaniLinuxmai masaukin baki zaiVestaCPpanelMySQL databaseHaɓaka zuwa sigar Mariadb 10.4.6.

Ba zato ba tsammani, shigar da umarni mai zuwa▼

mysql -uroot -p

• Shigar da kalmar sirri don shigaMySQL.

Kuskure mai zuwa yana faruwa ▼

ERROR 1045 (28000): An hana samun dama ga mai amfani 'tushen'@'localhost' (ta amfani da kalmar sirri: YES)

Yawancin lokaci wannan kuskuren yana haifar da kuskuren tushen kalmar sirri don bayanan MySQL, maganin ba shakka shine sake saita kalmar wucewa.

Yadda ake MySQL ERROR 1045 (28000) kuskure?

shafi na 1:amfani da SSH软件Bayan shiga, shigar da umarni mai zuwa don dakatar da bayanan mysql ▼

systemctl stop mysqld

shafi na 2:Fara MySQL tare da umarni mai zuwa kuma fara shi ba tare da duba izini ba ▼

mysqld --skip-grant-tables &

A wannan lokacin, an sake samun wani kuskure ▼

[KUSKURE] Kuskure mai kisa: Da fatan za a karanta sashin “Tsaro” na littafin don gano yadda ake gudanar da mysqld azaman tushen!

Da fatan za a SSH kuma shigar da umarni mai zuwa ▼

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

shafi na 3:SSH shiga cikin mysql ▼

mysql -uroot

或

mysql

shafi na 4:sabunta tushen kalmar sirri

Mysql5.7 ko kuma daga baya ▼

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

Mysql5.7 version ▼

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

shafi na 5:Sabunta izini ▼

flush privileges;

shafi na 6:fita mysql ▼ 

exit

或

quit

shafi na 7:Sake shiga mysql tare da tushen mai amfani ▼

Mysql -uroot -p

• Shigar da kalmar shiga:<输入刚改好的密码123456>