Skip to content

Instantly share code, notes, and snippets.

@livando

livando/myslnotes

Created January 9, 2013 15:17
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save livando/4493905 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save livando/4493905 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL notes
Raw
myslnotes
to change root user password
mysql -u root -h localhost -p
root
mysql> use mysql;
mysql> update user set password=PASSWORD("") where User='root';
mysql> flush privileges;
mysql> quit
update user set password=PASSWORD("foobar") where User='root';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment