Sida loo xalliyo MySQL ERROR 1045 (28000): Gelitaanka ayaa loo diiday isticmaalaha 'root'@'localhost'

markaad isku daydo inaad isticmaasho MySQL database, waxaa laga yaabaa inaad la kulanto fariinta khaladka ah ee soo socota:

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

Sida loo xaliyoMySQL Cillad 1045 (28000): Gelitaanka loo diiday isticmaale 'root'@'localhost'?

1. Jooji serverkaaga marka hore

service mysql stop

mkdir /var/run/mysqld

3. Sii MySQL ogolaansho si loo isticmaalo hagaha la abuuray.

chown mysql: /var/run/mysqld

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

mysql -u root mysql

ama:

mysql -u root mysql

Macmiilka mysql, u sheeg server-ka inuu dib u soo geliyo miisaska deeqda si bayaanada maamulka akoonku u shaqeeyaan:

mysql> FLUSH PRIVILEGES;

ka dibna wax ka beddel'root'@'localhost'lambarka sirta ah ee xisaabtaKu beddel erayga sirta ah erayga sirta ah ee aad rabto inaad isticmaasho.Si aad u bedesho erayga sirta ah ee koontada xididka oo leh qayb magaca martida loo yahay oo ka duwan, wax ka beddel tilmaamaha si aad u isticmaasho magaca martida loo yahay.

MySQL 5.7.6 iyo wixii ka dambeeya:

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

MySQL 5.7.5 iyo ka hor:

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

ama si toos ah miiska isticmaalayaasha:

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

ee XAMPP

Jooji adeegga MySQL,Fur daaqada amarka oo u beddel tusaha XAMPP MySQL:

> cd \xampp\mysql\bin\

Si aad u maamusho adeega bilaa amaan (xusuusnow in aad wado mysqld, ma aha mysql):

> mysqld.exe --skip-grant-tables

Adeegga MySQL wuxuu ku shaqayn doonaa daaqadan, markaa fur daaqad kale oo amar oo u beddel tusaha XAMPP MySQL:

> cd \xampp\mysql\bin\

Ku socodsii macmiilka MySQL:

> mysql

Cusbooneysii erayga sirta ah:

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

Jooji MySQL:

mysql> \q

Isticmaal maamulaha hawsha si aad u tirtirto mysqld.exe ee wali socda, oo dib u bilaw adeegga MySQL.