The final phase of the operation involves restoring the system to its normal, secure state. The user exits the MySQL shell and returns to the first command prompt window where the manual server is running. By pressing Ctrl+C or closing the window, the skip-grant-tables instance is terminated. The final step is to restart the MySQL service using the standard Windows service manager or the command net start MySQL . At this point, the database is running with standard security protocols re-enabled, and the root user can only be accessed using the newly set password.
Note: Adjust the path if you are utilizing an alternative version directory. Enter your current active password when prompted. Step 3: Execute the Password Alteration Query change mysql root password windows
, then restart MySQL normally:
net stop MySQL