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

Cusboonaysii xogta MySQL ee guddiga VestaCP una beddel MariaDB nooca 10.4.6 adoo isticmaalaya martigeliyaha Linux .

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: Ka dib markaad gasho adoo isticmaalaya software-ka SSH , geli amarka soo socda si aad u joojiso xogta MySQL ▼

systemctl stop mysqld

Tallaabada 2: Ku bilow MySQL adoo adeegsanaya amarka soo socda, adigoon hubin rukhsadaha ▼

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: Ku gal MySQL adoo adeegsanaya SSH ▼

mysql -uroot

Ama

mysql

Tallaabada 4: Cusboonaysii 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: Cusboonaysiinta Ogolaanshaha ▼

flush privileges;

Tallaabada 6: Ka bax MySQL ▼

exit

Ama

quit

Tallaabada 7: Ku gal MySQL mar kale adoo ah isticmaalaha xididka ▼

Mysql -uroot -p

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