Skip to content

Instantly share code, notes, and snippets.

@ggdio

ggdio/RESET MYSQL USER PASSWORD

Last active December 23, 2015 07:09
Show Gist options
  • Save ggdio/6599172 to your computer and use it in GitHub Desktop.
Save ggdio/6599172 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
RESET MYSQL USER PASSWORD
--Create a .txt file
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;
--Run the following command(OBS: replace the file_path)
%MYSQL_HOME%\bin\mysqld-nt --init-file=[FILE_PATH]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment