CODEWITHSUNDEEP
mysqlsqlcommand-promptchange-password
Falady
Falady

Reputation: 124

Failed to reset MySQL password

Recently I tried to reset mySQL password using command prompt using this instruction https://dev.mysql.com/doc/mysql-windows-excerpt/5.7/en/resetting-permissions-windows.html .

I did exactly as in the instruction but my it didn't turn out as how it is supposed to be. It just stopped there after I pressed enter, nothing happened, no errors or warnings or whatsoever. I even tried restarting the server with the new password.

here's the result of the command. like i said, no errors or warnings after i pressed enter. no errors nor warnings

and here's the error when i try to restart the server with the new password error

i expected this output here (i got this from a youtube video; the guy did exactly the same thing) expected outcome

Upvotes: 0

Views: 1945

Answers (1)

Maurice Pheyton
Maurice Pheyton

Reputation: 111

Tryout these steps:

  1. Stop your MySQL server completely. This can be done from Wamp(if you use it), or start “services.msc” using Run window, and stop the service there.

  2. Open your MS-DOS command prompt using “cmd” inside the Run window. Then go to your MySQL bin folder, such as C:\MySQL\bin. Path is different if you use Wamp.

  3. Execute the following command in the command prompt:

    mysqld.exe -u root --skip-grant-tables

  4. Leave the current MS-DOS command prompt as it is, and open a new MS-DOS command prompt window.

  5. Go to your MySQL bin folder again.

  6. Enter “mysql” and press enter.

  7. You should now have the MySQL command prompt working. Type “use mysql;” so that we switch to the “mysql” database.

  8. Execute the following command to update the password:

UPDATE user SET Password = PASSWORD('your_new_passowrd') WHERE User = 'root'; However, you can now run almost any SQL command that you wish.

After you are finished close the first command prompt, and type “exit;” in the second command prompt.

You can now start the MySQL service. That’s it.

Upvotes: 2

Related Questions