PM 77-1 PM 77-1 - 1 year ago 130
MySQL Question

Resetting ROOT password in MySQL 5.6

I have been following these instructions for resetting root password for local installation of

MySQL 5.6
on Windows 7 laptop.

I stopped the service, created init-file, and ran the following command (as Administrator):

"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.6\my.ini" --init-file=C:\\MySQL-misc\\mysql-init.txt

I got the following warning:

2014-02-08 15:44:10 0 [Warning] TIMESTAMP with implicit DEFAULT value
is deprecated. Please use --explicit_defaults_for_timestamp server
option (see documentation for more details).

Since it's a warning I'm not sure whether I need to fix anything and then redo the process again.

Currently the command window is still on and does not accept any input. Should I force-close it or is there anything I can do to complete the process gracefully?


I killed the Command window and tried to restart the service. Got an error.

Restarted Windows and the service automatically started. The new
root password
seems to work. I was successfully able to use various functions of Workbench that require the password.

So, the warning was indeed just a warning.

Answer Source

The issue has been resolved.

As stated in my question I followed instructions from MySQL manual.

The process did not go exactly as described (and this was the reason for my original post) but it worked nevertheless (see UPDATE section in my post).

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download