Salut, astazi va voi invata cum sa resetati parola la mysql(navicat). Urmariti-mi cu atentie pasii!
/usr/local/etc/rc.d/mysql-server stop
chown -R mysql /var/db/mysql && chgrp -R mysql /var/db/mysql
/usr/local/etc/rc.d/mysql-server start
/usr/local/etc/rc.d/mysql-server stop
Apoi
mysqld_safe --skip-grant-tables &
Apoi
mysql -u root
apoi
use mysql;
apoi
update user set password=PASSWORD("Parola aleasa intre ghilimele") where User='root';
apoi
flush privileges;
apoi
quit
Asta a fost tot. Bafta!
