Yadda ake warware MySQL ERROR 1045 (28000): An hana samun dama ga mai amfani 'tushen'@'localhost'

lokacin da kake ƙoƙarin amfani MySQL database, za ka iya ci karo da saƙon kuskure mai zuwa:

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

Yadda za a warwareMySQL ERROR 1045 (28000): An hana samun dama ga mai amfani 'tushen'@'localhost'?

1. Dakatar da uwar garken ku da farko

service mysql stop

mkdir /var/run/mysqld

3. Bada izinin MySQL don amfani da littafin da aka ƙirƙira.

chown mysql: /var/run/mysqld

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

mysql -u root mysql

ko:

mysql -u root mysql

A cikin abokin ciniki na mysql, gaya wa uwar garken don sake shigar da tebur ɗin kyauta don maganganun sarrafa asusun suyi aiki:

mysql> FLUSH PRIVILEGES;

sai a gyara'root'@'localhost'kalmar sirri ta asusun.Sauya kalmar sirri da kalmar sirri da kake son amfani da ita.Don canza kalmar sirri don tushen asusun tare da wani yanki na sunan mai masauki daban, gyara umarnin don amfani da sunan mai masaukin.

MySQL 5.7.6 kuma daga baya:

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

MySQL 5.7.5 da baya:

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

Ko kai tsaye akan teburin masu amfani:

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

don XAMPP

Dakatar da sabis na MySQL,Bude taga umarni kuma canza zuwa XAMPP MySQL directory:

> cd \xampp\mysql\bin\

Don gudanar da sabis ɗin ba tare da tsaro ba (lura cewa kuna gudana mysqld, ba mysql):

> mysqld.exe --skip-grant-tables

Sabis na MySQL zai gudana a cikin wannan taga, don haka buɗe wata taga umarni kuma canza zuwa XAMPP MySQL directory:

> cd \xampp\mysql\bin\

Gudanar da abokin ciniki na MySQL:

> mysql

Sabunta kalmar sirri:

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

Bar MySQL:

mysql> \q

Yi amfani da mai sarrafa ɗawainiya don soke mysqld.exe wanda ke gudana har yanzu, kuma sake kunna sabis na MySQL.