Mokhoa oa ho rarolla MySQL ERROR 1045 (28000): phihlello e hanetsoe bakeng sa mosebelisi 'root'@'localhost'

ha u leka ho sebelisa MySQL database, o ka kopana le molaetsa o latelang oa phoso:

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

Mokhoa oa ho rarollaMySQL ERROR 1045 (28000): phihlello e hanetsoe bakeng sa mosebelisi 'root'@'localhost'?

1. Emisa seva ea hau pele

service mysql stop

mkdir /var/run/mysqld

3. Fana ka tumello ea MySQL ea ho sebelisa bukana e entsoeng.

chown mysql: /var/run/mysqld

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

mysql -u root mysql

或：

mysql -u root mysql

Ho moreki oa mysql, bolella seva ho kenya litafole tsa lithuso hape e le hore lipolelo tsa taolo ea akhaonto li sebetse:

mysql> FLUSH PRIVILEGES;

ebe u fetola'root'@'localhost'password ea akhaonto.Tlosa phasewete ka password eo u batlang ho e sebelisa.Ho fetola phasewete bakeng sa motso oa akhaonto ka karolo e fapaneng ea lebitso la moamoheli, fetola litaelo ho sebelisa lebitso la moamoheli.

MySQL 5.7.6 le hamorao:

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

MySQL 5.7.5 le pejana:

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

kapa ka kotloloho tafoleng ea basebelisi:

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

Bakeng sa XAMPP

Emisa tšebeletso ea MySQL,Bula fensetere ea litaelo ebe u fetohela bukeng ea XAMPP MySQL:

> cd \xampp\mysql\bin\

Ho tsamaisa ts'ebeletso ntle le ts'ireletso (hlokomela hore u ntse u sebelisa mysqld, eseng mysql):

> mysqld.exe --skip-grant-tables

Ts'ebeletso ea MySQL e tla be e sebetsa fensetereng ena, kahoo bula fensetere e 'ngoe ea litaelo 'me u fetohele bukeng ea XAMPP MySQL:

> cd \xampp\mysql\bin\

Matha moreki oa MySQL:

> mysql

Ntlafatsa phasewete:

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

Tlosa MySQL:

mysql> \q

Sebelisa mookameli oa mosebetsi ho hlakola mysqld.exe e ntseng e sebetsa, 'me u qale tšebeletso ea MySQL hape.