忘记mysql密码？[freebsd]

原贴：http://www.humen1.com/labels/unix.html

忘记mysql密码？[freebsd]

#killall mysqld
#/usr/local/bin/mysqld_safe --skip-grant-tables &
#mysql
...
mysql>use mysql
mysql>update user set password=password("root") where user="root";
mysql>flush privileges;
mysql>exit

 

#killall mysqld

 

#/usr/local/etc/rc.d/mysql_server start

 

#mysql -u root -p
#Enter password: root
mysql>