Konzani ERROR 1045 (28000): Kufikira kwaletsedwa kwa wogwiritsa ntchito 'root' @ 'localhost' (pogwiritsa ntchito mawu achinsinsi: YES)

使用Linuxhost adzateroVestaCPguluMySQL databaseSinthani ku mtundu wa Mariadb 10.4.6.

Mosayembekezereka, lowetsani lamulo ili▼

mysql -uroot -p

• Lowetsani mawu achinsinsi kuti muloweMySQL.

Cholakwika chotsatirachi chikuchitika ▼

ERROR 1045 (28000): Kufikira kumakanidwa kwa wogwiritsa ntchito 'root' @ 'localhost' (pogwiritsa ntchito mawu achinsinsi: YES)

Nthawi zambiri cholakwika ichi chimayamba chifukwa cha mawu achinsinsi olakwika a MySQL data, yankho ndikukhazikitsanso mawu achinsinsi.

Momwe mungapangire cholakwika cha MySQL ERROR 1045 (28000)?

Khwerero 1:gwiritsani ntchito SSH软件Mukalowa, lowetsani lamulo ili kuti muyimitse database ya mysql ▼

systemctl stop mysqld

Khwerero 2:Yambitsani MySQL ndi lamulo ili ndikuyamba osayang'ana zilolezo ▼

mysqld --skip-grant-tables &

Panthawiyi, cholakwika china chinanenedwa ▼

[ERROR] Cholakwika chachikulu: Chonde werengani gawo la "Chitetezo" la bukhuli kuti mudziwe momwe mungayendetsere mysqld ngati mizu!

Chonde SSH ndikuyika lamulo lotsatirali ▼

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

Khwerero 3:SSH lowani ku mysql ▼

mysql -uroot

Kapena

mysql

Khwerero 4:sintha dzina lachinsinsi

Mysql5.7 kapena kenako ▼

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

Mtundu wa Mysql5.7 ▼

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

Khwerero 5:Zilolezo zotsitsimulanso ▼

flush privileges;

Khwerero 6:tulukani mysql ▼ 

exit

Kapena

quit

Khwerero 7:Lowaninso ku mysql ndi wogwiritsa ntchito mizu ▼

Mysql -uroot -p

• Lowani mawu achinsinsi:<输入刚改好的密码123456>