Sombulula i-ERROR 1045 (28000): Ufikelelo lwaliwe kumsebenzisi 'ingcambu'@'localhost' (usebenzisa igama eliyimfihlo: EWE)

使用Linuxumamkeli uyaVestaCPIphaneliMySQL databaseUphuculo ukuya kwinguqulo ye-Mariadb 10.4.6.

Ngokungalindelekanga, faka lo myalelo ulandelayo▼

mysql -uroot -p

• Ngenisa igama lokugqithisa ukuze ungenemysql,

Kwenzeka impazamo elandelayo ▼

ERROR 1045 (28000): Ufikelelo lwaliwe kumsebenzisi 'root'@'localhost' (usebenzisa igama eliyimfihlo: EWE)

Ngokuqhelekileyo le mpazamo ibangelwa yi-root user password engalunganga yedatha ye-MySQL, isisombululo ngokuqinisekileyo kukusetha kwakhona igama eligqithisiweyo.

Uyenza njani impazamo ye-MySQL 1045 (28000)?

Isiqendu 1:sebenzisa i-SSH软件Emva kokungena, ngenisa lo myalelo ulandelayo ukumisa isiseko sedatha se-mysql ▼

systemctl stop mysqld

Isiqendu 2:Qala i-MySQL ngalo myalelo ulandelayo kwaye uyiqale ngaphandle kokujonga iimvume ▼

mysqld --skip-grant-tables &

Ngeli xesha, kuye kwabikwa enye impazamo ▼

[I-ERROR] Impazamo ebulalayo: Nceda ufunde icandelo elithi "Ukhuseleko" lencwadana ukuze ufumane indlela yokuqhuba i-mysqld njengengcambu!

Nceda SSH kwaye ufake lo myalelo ulandelayo ▼

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

Isiqendu 3:Ngena nge-SSH kwi-mysql ▼

mysql -uroot

Okanye

mysql

Isiqendu 4:hlaziya igama eligqithisiweyo lengcambu

Mysql5.7 okanye kamva ▼

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

Uguqulelo lweMysql5.7 ▼

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

Isiqendu 5:Hlaziya iimvume ▼

flush privileges;

Isiqendu 6:phuma kwi-mysql ▼ 

exit

Okanye

quit

Isiqendu 7:Ngena kwakhona kwi-mysql ngengcambu yomsebenzisi ▼

Mysql -uroot -p

• Ngenisa igama lokugqithisa:<输入刚改好的密码123456>