kany · December 11, 2015 20:58
diff --git a/Reset MySQL 'root' user password b/Reset MySQL 'root' user password
 This method only works if currently logged in as root.  Sometimes when working with older ruby 'mysql' gems, after the 'mysql' gem is installed, the previous password doesn't work.

 1) Already logged into Mysql
 2) gem jacked up your mysql password
 3) mysql > use mysql;
 4) mysql > UPDATE user SET Password=PASSWORD('') WHERE User='root'; FLUSH PRIVILEGES;
	This method only works if currently logged in as root. Sometimes when working with older ruby 'mysql' gems, after the 'mysql' gem is installed, the previous password doesn't work.

	1) Already logged into Mysql
	2) gem jacked up your mysql password
	3) mysql > use mysql;
	4) mysql > UPDATE user SET Password=PASSWORD('') WHERE User='root'; FLUSH PRIVILEGES;