Whakaoti HAPA 1045 (28000): Karekau te uru mo te kaiwhakamahi 'pakiaka'@'localhost' (ma te kupuhipa: YES)

whakamahiLinuxte kaihautuVestaCPröpüpātengi raraunga MySQLWhakapai ake ki te putanga Mariadb 10.4.6.

I ohorere, tomo te tono e whai ake nei▼

mysql -uroot -p

• Whakauruhia te kupuhipa hei takiurumysql.

Ka puta te hapa e whai ake nei ▼

HAPA 1045 (28000): Karekau te uru mo te kaiwhakamahi 'pakiaka'@'localhost' (ma te kupuhipa: YES)

I te nuinga o te wa ka puta mai tenei hapa na te he kupuhipa kaiwhakamahi pakiaka mo nga raraunga MySQL, ko te otinga ko te tikanga ki te tautuhi i te kupuhipa.

Me pehea te hapa MySQL ERROR 1045 (28000)?

taahiraa 1:whakamahi SSH软件Whai muri i to takiuru, uruhia te whakahau e whai ake nei hei aukati i te paataka raraunga mysql ▼

systemctl stop mysqld

taahiraa 2:Tīmatahia a MySQL me te whakahau e whai ake nei ka tiimata me te kore e tirohia nga whakaaetanga ▼

mysqld --skip-grant-tables &

I tenei wa, he hapa ano te korero ▼

[HAPA] Hapa mate: Tena panuihia te waahanga "Haumarutanga" o te pukapuka kia mohio ai koe me pehea te whakahaere i te mysqld hei pakiaka!

Tena koa SSH ka tomo i te whakahau e whai ake nei ▼

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

taahiraa 3:Takiuru SSH ki mysql ▼

mysql -uroot

或

mysql

taahiraa 4:whakahou i te kupuhipa pakiaka

Mysql5.7 i muri mai ranei ▼

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

Mysql5.7 putanga ▼

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

taahiraa 5:Tāmata whakaaetanga ▼

flush privileges;

taahiraa 6:puta mysql ▼ 

exit

或

quit

taahiraa 7:Takiuru ano ki mysql me te kaiwhakamahi pakiaka ▼

Mysql -uroot -p

• Tomo kupuhipa:<输入刚改好的密码123456>