selfish
10/29/2014 - 10:36 AM

Resetting MySQL root password (from: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html)

Resetting MySQL root password (from: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html)

reset.bat
content_copyfile_download
:: Stop SQ SERVER BEFORE!!
C:\mysql\bin\mysqld --init-file=C:\mysql-init.txt --console
mysql-init.mysql
content_copyfile_download
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;