Littafin Adireshi
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
或:
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.
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) shared "MySQL ERROR 1045 (28000): An hana samun dama ga mai amfani 'tushen'@'localhost' yadda ake warwarewa" zai taimake ku.
Barka da zuwa raba hanyar haɗin wannan labarin:https://www.chenweiliang.com/cwl-30369.html
Barka da zuwa tashar Telegram na Chen Weiliang's blog don samun sabbin abubuwa!
📚 Wannan jagorar ya ƙunshi ƙima mai yawa, 🌟Wannan dama ce da ba kasafai ba, kar a rasa ta! ⏰⌛💨
Share da like idan kuna so!
Rarraba ku da abubuwan so sune ci gaba da ƙarfafa mu!