Xalli Cillad 1045 (28000): Gelitaanka ayaa loo diiday isticmaale 'root'@'localhost' (adoo isticmaalaya erayga sirta ah: HAA)

使用Linuxmartida loo yahayVestaCPguddidatabase MySQLU cusboonaysii nooca Mariadb 10.4.6.

Si lama filaan ah, geli amarka soo socda▼

mysql -uroot -p

• Geli furaha sirta ah si aad u gashoMySQL.

Cilada soo socota ayaa dhacda ▼

CALAD 1045 (28000): Gelitaanka ayaa loo diiday isticmaale 'root'@'localhost' (adoo isticmaalaya erayga sirta ah: HAA)

Caadi ahaan qaladkan waxaa sababa erayga sirta ah ee isticmaalaha xididka ah ee xogta MySQL, xalku waa dabcan dib u habeynta erayga sirta ah.

Sida loo sameeyo qaladka MySQL ERROR 1045 (28000)?

Tallaabada 1:isticmaal SSH软件Kadib markaad gasho, geli amarka soo socda si aad u joojiso xogta mysql ▼

systemctl stop mysqld

Tallaabada 2:Ku bilow MySQL amarka soo socda oo ku bilow adiga oo aan hubin ogolaanshaha ▼

mysqld --skip-grant-tables &

Halkaa marka ay marayso, khalad kale ayaa la soo sheegay ▼

Khalad dilaa ah: Fadlan akhri qaybta "Amniga" ee buug-gacmeedka si aad u ogaato sida loo maamulo mysqld xidid ahaan!

Fadlan SSH oo geli amarka soo socda ▼

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

Tallaabada 3:SSH gal mysql ▼

mysql -uroot

Ama

mysql

Tallaabada 4:cusbooneysii erayga sirta ah ee xididka

Mysql5.7 ama ka dib ▼

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

Mysql5.7 nooca ▼

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

Tallaabada 5:Dib u cusboonaysii ogolaanshaha ▼

flush privileges;

Tallaabada 6:ka bax mysql ▼ 

exit

Ama

quit

Tallaabada 7:Dib u gal mysql adiga oo isticmaalaya xididka isticmaalaha ▼

Mysql -uroot -p

• Geli password<输入刚改好的密码123456>