Dozie ERROR 1045 (28000): Ajụrụ anabata ohere maka onye ọrụ 'mgbọrọgwụ'@'localhost' (iji okwuntughe: EE)

使用Linuxonye ọbịa ga-VestaCPpanelMySQL nchekwa dataNweta nkwalite gaa na ụdị Mariadb 10.4.6.

Na mberede, tinye iwu a▼

mysql -uroot -p

• Tinye paswọọdụ iji banyeMySQL.

Njehie a na-eme ▼

ERROR 1045 (28000): Ajụjụ ohere maka onye ọrụ 'mgbọrọgwụ'@'localhost' (iji okwuntughe: EE)

Ọtụtụ mgbe njehie a na-akpata site na paswọọdụ onye ọrụ mgbọrọgwụ na-ezighi ezi maka data MySQL, azịza ya bụ n'ezie ịtọgharịa paswọọdụ.

Otu esi eme njehie MySQL ERROR 1045 (28000)?

nke 1:eji SSH软件Mgbe ịbanyechara, tinye iwu a ka ịkwụsị mysql nchekwa data ▼

systemctl stop mysqld

nke 2:Malite MySQL na iwu na-esonụ wee malite ya na-enweghị ịlele ikike ▼

mysqld --skip-grant-tables &

N'oge a, a kọrọ njehie ọzọ ▼

Njehie na-egbu egbu: Biko gụọ ngalaba "Nchekwa" nke akwụkwọ ntuziaka ka ị chọpụta ka esi agba mysqld dị ka mgbọrọgwụ!

Biko SSH ma tinye iwu a ▼

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

nke 3:Nbanye SSH na mysql ▼

mysql -uroot

或

mysql

nke 4:melite mgbọrọgwụ paswọọdụ

Mysql5.7 ma ọ bụ karịa ▼

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

Ụdị Mysql5.7 ▼

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

nke 5:Weghachite ikike ▼

flush privileges;

nke 6:wepụ mysql ▼ 

exit

或

quit

nke 7:Banye na mysql na onye ọrụ mgbọrọgwụ ▼

Mysql -uroot -p

• Tinye paswọọdụ:<输入刚改好的密码123456>