Bii o ṣe le yanju Aṣiṣe MySQL 1045 (28000): Iwọle ti kọ fun olumulo 'root'@'localhost'

Tí o bá gbìyànjú láti lo ibi ìpamọ́ MySQL , o lè rí ìránṣẹ́ àṣìṣe wọ̀nyí:

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

Bawo ni lati yanjuMySQL Aṣiṣe 1045 (28000): Iwọle kọ fun olumulo 'root'@'localhost'?

1. Duro olupin rẹ akọkọ

service mysql stop

mkdir /var/run/mysqld

3. Fifun MySQL igbanilaaye lati lo awọn da liana.

chown mysql: /var/run/mysqld

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

mysql -u root mysql

tabi:

mysql -u root mysql

Ninu alabara mysql, sọ fun olupin naa lati tun gbe awọn tabili ẹbun silẹ ki awọn alaye iṣakoso akọọlẹ ṣiṣẹ:

mysql> FLUSH PRIVILEGES;

lẹhinna yipada'root'@'localhost'ọrọigbaniwọle iroyin.Rọpo ọrọ igbaniwọle pẹlu ọrọ igbaniwọle ti o fẹ lo.Lati yi ọrọ igbaniwọle pada fun akọọlẹ gbongbo pẹlu ipin orukọ olupin ti o yatọ, tun awọn ilana naa lati lo orukọ olupin naa.

MySQL 5.7.6 ati nigbamii:

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

MySQL 5.7.5 ati ni iṣaaju:

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

Tabi taara lori tabili awọn olumulo:

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

Fun XAMPP

Láti dá iṣẹ́ MySQL dúró, ṣí fèrèsé àṣẹ kan kí o sì lọ sí ìwé àṣẹ XAMPP MySQL:

> cd \xampp\mysql\bin\

Lati ṣiṣẹ iṣẹ naa laisi aabo (ṣe akiyesi pe o nṣiṣẹ mysqld, kii ṣe mysql):

> mysqld.exe --skip-grant-tables

Iṣẹ MySQL yoo ṣiṣẹ ni window yii, nitorinaa ṣii window aṣẹ miiran ki o yipada si ilana XAMPP MySQL:

> cd \xampp\mysql\bin\

Ṣiṣe onibara MySQL:

> mysql

Ṣe imudojuiwọn ọrọ igbaniwọle:

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

Pa MySQL kuro:

mysql> \q

Lo oluṣakoso iṣẹ-ṣiṣe lati fagilee mysqld.exe ti o tun nṣiṣẹ, ki o tun bẹrẹ iṣẹ MySQL.