Momwe mungathetsere MySQL ERROR 1045 (28000): Kufikira kumakanidwa kwa wogwiritsa 'root'@'localhost'

pamene mukuyesera kugwiritsa ntchito MySQL database, mutha kukumana ndi zolakwika zotsatirazi:

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

Momwe mungathetsereMySQL ERROR 1045 (28000): Kufikira kwaletsedwa kwa wogwiritsa ntchito 'root'@'localhost'?

1. Imitsani seva yanu kaye

service mysql stop

mkdir /var/run/mysqld

3. Perekani chilolezo cha MySQL kuti mugwiritse ntchito bukhu lopangidwa.

chown mysql: /var/run/mysqld

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

mysql -u root mysql

kapena:

mysql -u root mysql

Mu kasitomala wa mysql, uzani seva kuti ikwezenso matebulo opereka chithandizo kuti mawu owongolera akaunti agwire ntchito:

mysql> FLUSH PRIVILEGES;

ndiye sinthani'root'@'localhost'chinsinsi cha akaunti.Sinthani mawu achinsinsi ndi mawu achinsinsi omwe mukufuna kugwiritsa ntchito.Kuti musinthe mawu achinsinsi a akaunti ya mizu ndi gawo lina la dzina la alendo, sinthani malangizo kuti mugwiritse ntchito dzina la olandila.

MySQL 5.7.6 ndi pambuyo pake:

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

MySQL 5.7.5 ndi kale:

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

Kapena mwachindunji pa tebulo la ogwiritsa ntchito:

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

Za XAMPP

Imitsa ntchito ya MySQL,Tsegulani zenera lalamulo ndikusintha ku chikwatu cha XAMPP MySQL:

> cd \xampp\mysql\bin\

Kuyendetsa ntchitoyo popanda chitetezo (zindikirani kuti mukuyendetsa mysqld, osati mysql):

> mysqld.exe --skip-grant-tables

Ntchito ya MySQL ikugwira ntchito pawindo ili, choncho tsegulani zenera lina la malamulo ndikusintha ku XAMPP MySQL directory:

> cd \xampp\mysql\bin\

Yendetsani kasitomala wa MySQL:

> mysql

Sinthani mawu achinsinsi:

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

Chotsani MySQL:

mysql> \q

Gwiritsani ntchito woyang'anira ntchito kuti muletse mysqld.exe yomwe ikugwirabe ntchito, ndikuyambitsanso ntchito ya MySQL.