E faʻafefea ona foia MySQL ERROR 1045 (28000): Faʻafitia le avanoa mo tagata 'aʻa'@'localhost'

pe a e taumafai e faʻaaoga MySQL database, e mafai ona e fetaiaʻi ma le faʻamatalaga sese:

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

Auala e foia aiMySQL ERROR 1045 (28000): Ua le maua le avanoa mo tagata 'a'a'@'localhost'?

1. Taofi muamua lau server

service mysql stop

mkdir /var/run/mysqld

3. Tuuina atu le faatagaga mai MySQL e faʻaaoga ai le lisi na faia.

chown mysql: /var/run/mysqld

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

mysql -u root mysql

或：

mysql -u root mysql

I le mysql client, taʻu i le 'auʻaunaga e toe faʻapipiʻi laulau faʻameaalofa ina ia aoga faʻamatalaga o le pulega o tala:

mysql> FLUSH PRIVILEGES;

ona sui lea'root'@'localhost'upu faataga tala.Sui upu faataga i le upu faataga e te manao e faaaoga.Ina ia suia le uputatala mo le root account ma se isi vaega ole igoa ole igoa, suia faatonuga e faaaoga ai lena igoa ole igoa.

MySQL 5.7.6 ma mulimuli ane:

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

MySQL 5.7.5 ma muamua atu:

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

pe tuusa'o i luga ole laulau a tagata fa'aoga:

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

Mo XAMPP

Taofi le auaunaga MySQL,Tatala se faamalama o le poloaiga ma sui i le XAMPP MySQL directory:

> cd \xampp\mysql\bin\

Le faʻatinoina o le 'auʻaunaga e aunoa ma se puipuiga (ia maitauina o loʻo e taʻavale mysqld, ae le o mysql):

> mysqld.exe --skip-grant-tables

O le a tamoʻe le auaunaga MySQL i lenei faamalama, ia tatala se isi faʻamalama faʻatonu ma sui i le XAMPP MySQL directory:

> cd \xampp\mysql\bin\

Faʻaauau le MySQL client:

> mysql

Faafou upu faataga:

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

Tuu le MySQL:

mysql> \q

Fa'aoga le pule o galuega e fa'aleaogaina ai le mysqld.exe o lo'o fa'aauau pea, ma toe amata le auaunaga MySQL.