Waiting for the wind

programming memo in different platforms

「mysql’s Road」分類文章彙整

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

發表於 mysql's Road, web programming, Win32's Road | 已加上的標籤: , , , | 張貼留言 »

 
Follow

Get every new post delivered to your Inbox.