windows mysql reset root
發文作者 cotton5415 於 四月 28, 2011
http://dev.mysql.com/doc/mysql-windows-excerpt/5.0/en/resetting-permissions-windows.html
1. stop mysql service.
2. edit a file abcd.sql
UPDATE mysql.user SET Password=PASSWORD(‘MyNewPass’) WHERE User=’root’;
FLUSH PRIVILEGES;
3. mysqld.exe –console –init-file=abcd.sql
4. new root password = MyNewPass
