Home>

I don't know the root password for mysql8.0 and I'm looking for a solution on various sites.
Reference site: https://www-creators.com/archives/5574#MySQL-2
But in the early stages

$mysql.server stop
$mysqld_safe --skip-grant-tables&

Each of these two spits out the following message, and I am in trouble because I can not execute it.

'mysql.server' is an internal or external command,
It is not recognized as an operable program or batch file.


At the command prompt, go to ‘C: \ Program Files \ MySQL \ MySQL Server 8.0 \ bin’ and then go.

I don't know where to fix it to start mysql in safe mode, so please help anyone who knows the solution. Please.

[environment]
OS: windows10
Mysql: Ver 8.0.19 for Win64 on x86_64

  • Answer # 1

    For Windows, click here Reference,

    B.3.3.2.1 Resetting the Root Password: Make sure it is written in Windows Systems.

    People who have been translated into Japanese easily: [MySQL8] In some cases, I got error 1045 on Windows and could not log in, so please refer to it.