Otu esi edozi MySQL ERROR 1045 (28000): Ajụjụ ohere maka onye ọrụ 'mgbọrọgwụ'@'localhost'

Mgbe ị na-agbalị iji nchekwa data MySQL , ị nwere ike ịhụ ozi njehie ndị 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

ma ọ bụ:

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

Iji kwụsị ọrụ MySQL, mepee windo iwu wee 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.