Rarolla ERROR 1045 (28000): Phihlello e hanetsoe bakeng sa mosebelisi 'root'@'localhost' (ho sebelisa password: YES)

sebedisaLinuxmoamoheli o tlaVestaCPphaneleMySQL databaseNtlafatsa ho mofuta oa Mariadb 10.4.6.

Ho sa lebelloa, kenya taelo e latelang▼

mysql -uroot -p

• Kenya phasewete ho kenaMySQL.

Phoso e latelang e etsahala ▼

ERROR 1045 (28000): phihlello e hanetsoe bakeng sa mosebelisi 'root'@'localhost' (ho sebelisa password: YES)

Hangata phoso ena e bakoa ke phasewete e fosahetseng ea mosebelisi bakeng sa data ea MySQL, tharollo ke ho seta phasewete bocha.

U ka etsa phoso ea MySQL ERROR 1045 (28000) joang?

Likhahlelo tsa 1:sebelisa SSH软件Kamora ho kena, kenya taelo e latelang ho emisa database ea mysql ▼

systemctl stop mysqld

Likhahlelo tsa 2:Qala MySQL ka taelo e latelang 'me u e qale ntle le ho hlahloba tumello ▼

mysqld --skip-grant-tables &

Mothating ona, ho ile ha tlalehoa phoso e 'ngoe ▼

[ERROR] Phoso e bolaeang: Ka kopo bala karolo ea "Tsireletso" ea bukana ho fumana mokhoa oa ho tsamaisa mysqld joalo ka motso!

Ka kopo SSH 'me u kenye taelo e latelang ▼

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

Likhahlelo tsa 3:SSH ho kena ho mysql ▼

mysql -uroot

Kapa

mysql

Likhahlelo tsa 4:ntlafatsa password ea motso

Mysql5.7 kapa hamorao ▼

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

Mofuta oa Mysql5.7 ▼

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

Likhahlelo tsa 5:Tsosolosa litumello ▼

flush privileges;

Likhahlelo tsa 6:tsoa ho mysql ▼ 

exit

Kapa

quit

Likhahlelo tsa 7:Kena hape ho mysql ka mosebelisi oa motso ▼

Mysql -uroot -p

• Kenya phasewete:<输入刚改好的密码123456>