Gadzirisa ERROR 1045 (28000): Kupinda kwakarambwa kumushandisi 'mudzi' @ 'localhost' (uchishandisa password: YES)

使用Linuxhost willVestaCPpanelMySQL databaseSimudzira kuMariadb vhezheni 10.4.6.

Zvisingatarisirwi, isa murairo unotevera▼

mysql -uroot -p

• Isa password kuti upindemysql.

Kukanganisa kunotevera kunoitika ▼

ERROR 1045 (28000): Kupinda kwakarambidzwa kumushandisi 'mudzi' @ 'localhost' (uchishandisa password: YES)

Kazhinji kukanganisa uku kunokonzerwa neiyo isiriyo mudzi mushandisi password yeMySQL data, mhinduro ndeyechokwadi kugadzirisa zvakare password.

Maitiro ekuita MySQL ERROR 1045 (28000) kukanganisa?

Chikamu 1 步:shandisa SSH软件Mushure mekupinda mukati, isa unotevera kuraira kumisa mysql dhatabhesi ▼

systemctl stop mysqld

Chikamu 2 步:Tanga MySQL nemurairo unotevera uye utange usina kutarisa mvumo ▼

mysqld --skip-grant-tables &

Panguva ino, kumwe kukanganisa kwakashumwa ▼

[ERROR] Chikanganiso chinouraya: Ndokumbira uverenge "Chengetedzo" chikamu chebhuku kuti uone maitiro ekuita mysqld semudzi!

Ndapota SSH uye isa murairo unotevera ▼

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

Chikamu 3 步:SSH kupinda kune mysql ▼

mysql -uroot

Kana

mysql

Chikamu 4 步:gadzirisa root password

Mysql5.7 kana gare gare ▼

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

Mysql5.7 shanduro ▼

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

Chikamu 5 步:Mutsidzira mvumo ▼

flush privileges;

Chikamu 6 步:kubuda mysql ▼ 

exit

Kana

quit

Chikamu 7 步:Pindazve kune mysql nemudzi wemushandisi ▼

Mysql -uroot -p

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