Uyixazulula kanjani i-MySQL ERROR 1045 (28000): Ukufinyelela kunqatshelwe ku-'root'@'localhost' yomsebenzisi

uma uzama ukusebenzisa MySQL database, ungase uhlangabezane nomlayezo wephutha olandelayo:

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

Indlela yokuxazululaMySQL IPHUTHA 1045 (28000): Ukufinyelela kunqatshelwe kumsebenzisi othi 'root'@'localhost'?

1. Misa iseva yakho kuqala

service mysql stop

mkdir /var/run/mysqld

3. Nikeza i-MySQL imvume yokusebenzisa uhla lwemibhalo oludaliwe.

chown mysql: /var/run/mysqld

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

mysql -u root mysql

noma:

mysql -u root mysql

Kuklayenti le-mysql, tshela iseva ukuthi ilayishe kabusha amatafula esibonelelo ukuze izitatimende zokuphatha i-akhawunti zisebenze:

mysql> FLUSH PRIVILEGES;

bese ulungisa'root'@'localhost'iphasiwedi ye-akhawunti.Faka esikhundleni iphasiwedi ofuna ukuyisebenzisa.Ukuze ushintshe iphasiwedi ye-akhawunti yempande enengxenye ehlukile yegama lomethuleli, lungisa imiyalelo ukuze usebenzise lelo gama lomethuleli.

I-MySQL 5.7.6 nakamuva:

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

I-MySQL 5.7.5 nangaphambilini:

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

noma ngokuqondile kuthebula labasebenzisi:

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

OkweXAMPP

Misa isevisi ye-MySQL,Vula iwindi lomyalo bese ushintshela kumkhombandlela we-XAMPP MySQL:

> cd \xampp\mysql\bin\

Ukuze usebenzise isevisi ngaphandle kokuphepha (qaphela ukuthi usebenzisa i-mysqld, hhayi i-mysql):

> mysqld.exe --skip-grant-tables

Isevisi ye-MySQL izosebenza kuleli windi, ngakho-ke vula elinye iwindi lomyalo bese ushintshela kumkhombandlela we-XAMPP MySQL:

> cd \xampp\mysql\bin\

Qalisa iklayenti le-MySQL:

> mysql

Buyekeza iphasiwedi:

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

Susa i-MySQL:

mysql> \q

Sebenzisa umphathi womsebenzi ukuze ukhansele i-mysqld.exe esaqhubeka, bese uqala kabusha isevisi ye-MySQL.