Yuav ua li cas los daws MySQL ERROR 1045 (28000): Kev nkag tsis pom zoo rau cov neeg siv 'root'@'localhost'

thaum koj sim siv MySQL database, koj yuav ntsib cov lus yuam kev hauv qab no:

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

Yuav daws li casMySQL XYOO 1045 (28000): Kev nkag tsis tau rau tus neeg siv 'root'@'localhost'?

1. nres koj lub server ua ntej

service mysql stop

mkdir /var/run/mysqld

3. Tso cai rau MySQL siv cov npe tsim.

chown mysql: /var/run/mysqld

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

mysql -u root mysql

或：

mysql -u root mysql

Hauv mysql tus thov kev pab, qhia rau tus neeg rau zaub mov kom rov rub lub rooj pub nyiaj kom cov lus tswj hwm tus account ua haujlwm:

mysql> FLUSH PRIVILEGES;

ces hloov'root'@'localhost'tus account password.Hloov lo lus zais nrog tus password koj xav siv.Txhawm rau hloov tus password rau tus account hauv paus nrog ib feem sib txawv hostname, hloov cov lus qhia siv lub npe hostname.

MySQL 5.7.6 thiab tom qab ntawd:

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

MySQL 5.7.5 thiab ua ntej:

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

los yog ncaj qha rau ntawm cov neeg siv lub rooj:

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

Rau XAMPP

Nres qhov kev pabcuam MySQL,Qhib lub qhov rais hais kom ua thiab hloov mus rau XAMPP MySQL directory:

> cd \xampp\mysql\bin\

Txhawm rau khiav qhov kev pabcuam yam tsis muaj kev ruaj ntseg (nco ntsoov tias koj tab tom khiav mysqld, tsis yog mysql):

> mysqld.exe --skip-grant-tables

Qhov kev pabcuam MySQL yuav khiav hauv lub qhov rais no, yog li qhib lwm lub qhov rais thiab hloov mus rau XAMPP MySQL directory:

> cd \xampp\mysql\bin\

Khiav MySQL tus thov kev pab:

> mysql

Hloov tshiab password:

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

Tawm MySQL:

mysql> \q

Siv tus thawj tswj haujlwm kom tshem tawm mysqld.exe uas tseem tab tom khiav, thiab rov pib qhov kev pabcuam MySQL.