Skip to content

Instantly share code, notes, and snippets.

@cristianstan

cristianstan/MySql: Change mysql user password using ssh.sql

Created February 28, 2014 21:22
Show Gist options
  • Save cristianstan/9280166 to your computer and use it in GitHub Desktop.
Save cristianstan/9280166 to your computer and use it in GitHub Desktop.
Download ZIP
MySql: Change mysql user password using ssh
Raw
MySql: Change mysql user password using ssh.sql
// That should start up mysql without the need for a root password. Once in, type
use mysql
UPDATE mysql.user SET password=PASSWORD('newpass') WHERE user='root';
FLUSH PRIVILEGES;
exit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment