Home > database >  The thief difficult ERROR 1045 (28000) : Access denied for user 'root' @ 'localhost&#
The thief difficult ERROR 1045 (28000) : Access denied for user 'root' @ 'localhost&#

Time:11-10

Bosses, rookie a self-study MySQL, recently installed version is 5.6, the
Learn to manage database users last week, in sqlyog midpoint, don't know whether this reason, this week link database appear the following error,


Then see various tutorials, mostly the skip - grant - tables, reset the password.
Corresponding user reset before, localhost is empty


After a reset, and refresh permissions,

Restart the service, even to restart the computer, the result is still the same, already have two days, head ache, ever who met this kind of situation,

In addition I installed mysql5.6, only a my - the default installation directory. The ini file, under the [mysqld] add skip_grant_tables doesn't work
Under the CMD running mysqld -- will still have to skip - grant - tables can be, no my. Ini and my CNF file,



CodePudding user response:

About port being used, also tried, useless, it seems that only reshipment,
Is run from entry to delete repository

CodePudding user response:

Command inside maybe add a -h host specified line
  • Related