使用Linuxumphathi uzoVestaCPiphaneliMySQL databaseThuthukela ku-Mariadb inguqulo 10.4.6.
Ngokungazelelwe, faka umyalo olandelayo▼
mysql -uroot -p
- Faka iphasiwedi ukuze ungenemysql,
Kuvela iphutha elilandelayo ▼
IPHUTHA 1045 (28000): Ukufinyelela kunqatshelwe kumsebenzisi othi 'root'@'localhost' (kusetshenziswa iphasiwedi: YEBO)
Ngokuvamile leli phutha libangelwa iphasiwedi engalungile yomsebenzisi wedatha ye-MySQL, isixazululo ukusetha kabusha iphasiwedi.
Ulenza kanjani iphutha le-MySQL ERROR 1045 (28000)?
Isinyathelo sesi-1:sebenzisa i-SSH软件Ngemva kokungena ngemvume, faka umyalo olandelayo ukuze umise i-mysql database ▼
systemctl stop mysqld
Isinyathelo sesi-2:Qala i-MySQL ngomyalo olandelayo bese uyiqala ngaphandle kokuhlola izimvume ▼
mysqld --skip-grant-tables &
Kuleli qophelo, kubikwe elinye iphutha ▼
[IPHUTHA] Iphutha eliyingozi: Sicela ufunde isigaba esithi “Security” sebhukwana ukuze uthole ukuthi i-mysqld isetshenziswa kanjani njengempande!
Sicela u-SSH bese ufaka umyalo olandelayo ▼
mysqld --user=root --skip-grant-tables &
Isinyathelo sesi-3:Ukungena ngemvume kwe-SSH ku-mysql ▼
mysql -uroot
Noma
mysql
Isinyathelo sesi-4:buyekeza iphasiwedi yezimpande
I-Mysql5.7 noma kamuva ▼
UPDATE mysql.user SET Password=PASSWORD('123456') where USER='root';
Inguqulo ye-Mysql5.7 ▼
UPDATE mysql.user SET authentication_string=PASSWORD('123456') where USER='root';
Isinyathelo sesi-5:Vuselela izimvume ▼
flush privileges;
Isinyathelo sesi-6:phuma ku-mysql ▼
exit
Noma
quit
Isinyathelo sesi-7:Ngena kabusha ku-mysql nomsebenzisi wempande ▼
Mysql -uroot -p
- Faka iphasiwedi:
<输入刚改好的密码123456>
I-Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) kwabelwane ngokuthi "Ukuxazulula IPHUTHA 1045 (28000): Ukufinyelela kunqatshelwe kumsebenzisi 'root'@'localhost' (kusetshenziswa iphasiwedi: YEBO)", okuwusizo kuwe.
Siyakwamukela ukwabelana ngesixhumanisi salesi sihloko:https://www.chenweiliang.com/cwl-1094.html
Uyemukelwa esiteshini seTelegram sebhulogi ka-Chen Weiliang ukuze uthole izibuyekezo zakamuva!
📚 Lo mhlahlandlela uqukethe inani elikhulu, 🌟Leli ithuba eliyivelakancane, ungaphuthelwa! ⏰⌛💨
Yabelana futhi uthanda uma uthanda!
Ukwabelana kwakho nokuthanda kwakho kuyisisusa sethu esiqhubekayo!