Fo'ia ERROR 1045 (28000): Ua le maua le avanoa mo le tagata fa'aoga 'a'a'@'localhost' (fa'aaoga upu fa'aigoa: IOE)

faʻaaogāLinuxloto talimaloVestaCPlaulauMySQL databaseFa'aleleia ile Mariadb version 10.4.6.

Fa'afuase'i, fa'aofi le fa'atonuga lea▼

mysql -uroot -p

• Ulufale upu faataga e saini aimysql.

O lo'o tupu le mea sese ▼

ERROR 1045 (28000): Te'ena le avanoa mo le tagata 'a'a'@'localhost' (fa'aoga upu fa'aoga: IOE)

E masani lava o lenei mea sese e mafua mai i le upu faʻaoga sese a le tagata faʻaoga mo MySQL data, o le fofo o le mea moni e toe setiina le upu faʻaulu.

E faʻafefea le MySQL ERROR 1045 (28000) sese?

Laasaga 1:fa'aoga SSHPolokalameA uma ona e saini i totonu, ulufale i le poloaiga lenei e taofi le mysql database ▼

systemctl stop mysqld

Laasaga 2:Amata MySQL i le poloaiga lenei ma amata e aunoa ma le siakiina o faʻatagaga ▼

mysqld --skip-grant-tables &

I le taimi lea, ua lipotia mai se isi mea sese ▼

[SESES] Fa'alavelave fa'afuase'i: Fa'amolemole faitau le vaega "Saogalemu" o le tusi lesona e su'e ai pe fa'afefea ona fa'a'a'a mysqld!

Fa'amolemole SSH ma fa'aofi le fa'atonuga ▼

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

Laasaga 3:SSH login ile mysql ▼

mysql -uroot

或

mysql

Laasaga 4:faafou upu faataga a'a

Mysql5.7 poʻo mulimuli ane ▼

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

Mysql5.7 version ▼

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

Laasaga 5:Toe faafou faatagaga ▼

flush privileges;

Laasaga 6:alu ese mai mysql ▼ 

exit

或

quit

Laasaga 7:Toe fa'aoga ile mysql ma le a'a fa'aoga ▼

Mysql -uroot -p

• Ulufale upu faʻamau:<输入刚改好的密码123456>