Maitiro ekugadzirisa MySQL ERROR 1045 (28000): Kupinda kwakarambwa kumushandisi 'mudzi' @ 'localhost'

paunoedza kushandisa MySQL database, unogona kusangana neinotevera mhosho meseji:

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

Kugadzirisa seiMySQL ERROR 1045 (28000): Kupinda kwakarambwa kumushandisi 'mudzi' @ 'localhost'?

1. Misa server yako kutanga

service mysql stop

mkdir /var/run/mysqld

3. Ipa MySQL mvumo yekushandisa dhairekitori rakagadzirwa.

chown mysql: /var/run/mysqld

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

mysql -u root mysql

或：

mysql -u root mysql

Mune mysql mutengi, taurira sevha kuti idzorezve matafura ekupa kuitira kuti zvirevo zvekutonga account zvishande:

mysql> FLUSH PRIVILEGES;

wobva wagadzirisa'root'@'localhost'account password.Chinja password nepassword yaunoda kushandisa.Kuti uchinje password yemudzi account ine rakasiyana hostname chikamu, shandura mirairo yekushandisa iro zita remuenzi.

MySQL 5.7.6 uye gare gare:

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

MySQL 5.7.5 uye yapfuura:

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

kana zvakananga patafura yevashandisi:

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

Ye XAMPP

Misa iyo MySQL sevhisi,Vhura hwindo rekuraira uye chinja kune XAMPP MySQL dhairekitori:

> cd \xampp\mysql\bin\

Kumhanyisa sevhisi pasina chengetedzo (ona kuti uri kumhanya mysqld, kwete mysql):

> mysqld.exe --skip-grant-tables

Iyo MySQL sevhisi ichave ichishanda muhwindo iri, saka vhura rimwe hwindo rekuraira uye chinja kune XAMPP MySQL dhairekitori:

> cd \xampp\mysql\bin\

Mhanya iyo MySQL mutengi:

> mysql

Gadziridza password:

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

Bvisa MySQL:

mysql> \q

Shandisa maneja webasa kudzima mysqld.exe iyo ichiri kushanda, uye tangazve iyo MySQL sevhisi.