FreeBSD MySQL忘记密码

今天使用時出現

ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (61)

其實是忘記密碼啦XDD

#背景執行mysql安全模式

mysqld_safe -u root –skip-grant-tables &

#登入mysql(不用密碼)

mysql -u root -p

>use mysql

>UPDATE user SET password=password(‘這裡輸入你的密碼’) where user=’root’;

>FLUSH PRIVILEGES;

>exit

/usr/local/etc/rc.d/mysql-server restart

Drop Your Comment