Me pehea te whakaoti i te MySQL ERROR 1045 (28000): Karekau te uru mo te kaiwhakamahi 'pakiaka'@'localhost'

ka ngana koe ki te whakamahi MySQL pātengi raraunga, ka tūpono pea koe ki te karere hapa e whai ake nei:

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

Me pehea te whakaotiMySQL HAPA 1045 (28000): Karekau te uru mo te kaiwhakamahi 'pakiaka'@'localhost'?

1. Kati to tūmau i te tuatahi

service mysql stop

mkdir /var/run/mysqld

3. Whakaaetia a MySQL ki te whakamahi i te whaiaronga i hangaia.

chown mysql: /var/run/mysqld

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

mysql -u root mysql

ranei:

mysql -u root mysql

I roto i te kiritaki mysql, mea atu ki te kaimau kia utaina ano nga ripanga tuku kia pai ai nga korero whakahaere kaute:

mysql> FLUSH PRIVILEGES;

katahi ka whakarereke'root'@'localhost'kupuhipa pūkete.Whakakapihia te kupuhipa ki te kupuhipa e hiahia ana koe ki te whakamahi.Hei huri i te kupuhipa mo te putea pakiaka me tetahi waahanga ingoa rangatira rereke, whakarereke i nga tohutohu hei whakamahi i taua ingoa manaaki.

MySQL 5.7.6 me muri ake:

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

MySQL 5.7.5 me mua atu:

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

tika ranei i runga i te ripanga kaiwhakamahi:

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

Mo XAMPP

Kati te ratonga MySQL,Whakatuwheratia he matapihi whakahau ka huri ki te raarangi XAMPP MySQL:

> cd \xampp\mysql\bin\

Hei whakahaere i te ratonga me te kore haumaru (kia mohio kei te whakahaere koe i te mysqld, ehara i te mysql):

> mysqld.exe --skip-grant-tables

Ka rere te ratonga MySQL i tenei matapihi, na reira whakatuwheratia tetahi atu matapihi whakahau ka huri ki te raarangi XAMPP MySQL:

> cd \xampp\mysql\bin\

Whakahaerehia te kiritaki MySQL:

> mysql

Whakahōu kupuhipa:

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

Waiho MySQL:

mysql> \q

Whakamahia te kaiwhakahaere mahi ki te whakakore i te mysqld.exe e rere tonu ana, ka whakaara ano i te ratonga MySQL.