Tusaha Maqaalka
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
或:
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.
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) la wadaagay "MySQL ERROR 1045 (28000): Gelitaanka loo diiday isticmaale 'root'@'localhost' sida loo xalliyo" ayaa ku caawin doonta.
Ku soo dhawoow inaad wadaagto xiriirka maqaalkan:https://www.chenweiliang.com/cwl-30369.html
Ku soo dhawoow kanaalka Telegramka ee Chen Weiliang's blog si aad u hesho wararkii ugu dambeeyay!
📚 Hagahan waxa uu ka kooban yahay qiimo aad u weyn, 🌟Tani waa fursad naadir ah, ha seegin! ⏰⌛💨
Share iyo like saar hadaad jeceshahay!
Wadaagistaada iyo jeceylkaaga ayaa ah dhiirigelintayada joogtada ah!