Uyisombulula njani i-MySQL ERROR 1045 (28000): Ufikelelo lwaliwe kumsebenzisi 'ingcambu'@'localhost'

Xa uzama ukusebenzisa MySQL Xa ufikelela kwisiseko sedatha, unokuhlangabezana nalo myalezo wemposiso ulandelayo:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Indlela yokusombululaMySQL IPHUTHA 1045 (28000): Ufikelelo lwaliwe kumsebenzisi 'ingcambu'@'localhost'?

1. Qala umise iseva yakho

service mysql stop

mkdir /var/run/mysqld

3. Nika imvume yeMySQL yokusebenzisa uvimba weefayili owenziweyo.

chown mysql: /var/run/mysqld

mysqld_safe --skip-grant-tables --skip-networking &

mysql -u root mysql

或：

mysql -u root mysql

Kumxhasi we-mysql, xelela umncedisi ukuba alayishe kwakhona iitafile zogunyaziso ukuze iingxelo zolawulo lwe-akhawunti zisebenze:

mysql> FLUSH PRIVILEGES;

kwaye ke ulungise'root'@'localhost'igama lokugqitha leakhawunti. Faka igama lokugqitha endaweni ofuna ukulisebenzisa. Ukutshintsha igama lokugqitha le akhawunti yengcambu enesahlulo segama lenginginya elahlukileyo, guqula kancinane imiyalelo yokusebenzisa elo gama lenginginya.

I-MySQL 5.7.6 nangaphezulu:

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';

I-MySQL 5.7.5 nangaphambili:

mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');

Okanye ngokuthe ngqo kwitafile yomsebenzisi:

UPDATE mysql.user SET password=PASSWORD('mynewpassword') WHERE user='root';

XAMPP kuphela

Misa inkonzo yeMySQL,Vula iwindow yomyalelo kwaye utshintshe kwi-XAMPP MySQL directory:

> cd \xampp\mysql\bin\

Ukwenza inkonzo ngaphandle kokhuseleko (qaphela ukuba usebenzisa i-mysqld, hayi i-mysql):

> mysqld.exe --skip-grant-tables

Inkonzo ye-MySQL iya kuqhuba kule festile, ngoko vula enye iwindow yomyalelo kwaye utshintshe kwi-XAMPP MySQL directory:

> cd \xampp\mysql\bin\

Qhuba umxhasi weMySQL:

> mysql

Hlaziya igama lokugqithisa:

mysql> UPDATE mysql.user SET password=PASSWORD('mynewpassword') WHERE user='root';

Phuma kuMySQL:

mysql> \q

Sebenzisa uMphathi woMsebenzi ukurhoxisa i-mysqld.exe esebenzayo kwaye uqalise kwakhona inkonzo ye-MySQL.