Akwụkwọ ndekọ ederede
mgbe ị na-agbalị iji MySQL nchekwa data, ị nwere ike izute ozi njehie a:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Otu esi edoziMySQL ERROR 1045 (28000): Ajụjụ ohere maka onye ọrụ 'mgbọrọgwụ'@'localhost'?
1. Kwụsị ihe nkesa gị mbụ
service mysql stop
mkdir /var/run/mysqld
3. Nye MySQL ikike iji kere ndekọ.
chown mysql: /var/run/mysqld
mysqld_safe --skip-grant-tables --skip-networking &
mysql -u root mysql
或:
mysql -u root mysql
Na onye ahịa mysql, gwa ihe nkesa ka ọ bugharịa tebụl onyinye ka nkwupụta njikwa akaụntụ wee rụọ ọrụ:
mysql> FLUSH PRIVILEGES;
wee gbanwee'root'@'localhost'
paswọọdụ akaụntụ.Jiri okwuntughe nke ịchọrọ iji dochie okwuntughe.Ka ịgbanwee okwuntughe maka akaụntụ mgbọrọgwụ nwere akụkụ aha nnabata dị iche, gbanwee ntuziaka ka ị jiri aha nnabata ahụ.
MySQL 5.7.6 na mgbe e mesịrị:
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass';
MySQL 5.7.5 na mbụ:
mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass');
ma ọ bụ ozugbo na tebụl ndị ọrụ:
UPDATE mysql.user SET password=PASSWORD('mynewpassword') WHERE user='root';
Maka XAMPP
Kwụsị ọrụ MySQL,Mepee windo iwu wee gbanwee gaa na ndekọ XAMPP MySQL:
> cd \xampp\mysql\bin\
Iji mee ọrụ ahụ na-enweghị nchekwa (rịba ama na ị na-agba mysqld, ọ bụghị mysql):
> mysqld.exe --skip-grant-tables
Ọrụ MySQL ga na-agba ọsọ na mpio a, yabụ mepee windo iwu ọzọ wee gbanwee na ndekọ XAMPP MySQL:
> cd \xampp\mysql\bin\
Gbaa onye ahịa MySQL:
> mysql
Melite okwuntughe:
mysql> UPDATE mysql.user SET password=PASSWORD('mynewpassword') WHERE user='root';
Kwụsị MySQL:
mysql> \q
Jiri njikwa ọrụ kagbuo mysqld.exe nke ka na-arụ ọrụ, wee malitegharịa ọrụ MySQL.
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) na-ekerịta "MySQL ERROR 1045 (28000): Ajụjụ ohere maka onye ọrụ 'mgbọrọgwụ'@'localhost' otu esi edozi" ga-enyere gị aka.
Nnọọ ka ị kesaa njikọ nke akụkọ a:https://www.chenweiliang.com/cwl-30369.html
Nabata na ọwa Telegram nke blọgụ Chen Weiliang ka ị nweta mmelite kachasị ọhụrụ!
📚 Ntuziaka a nwere nnukwu uru, 🌟Nke a bụ ohere dị ụkọ, echefula ya! ⏰⌛💨
Kekọrịta na-amasị ma ọ bụrụ na-amasị gị!
Ịkekọrịta na mmasị gị bụ mkpali anyị na-aga n'ihu!