Schimbare parola MySQL

/usr/local/etc/rc.d/mysql-server stop
mysqld_safe –skip-grant-tables &
mysql -u root
use mysql;
update user set password=PASSWORD(“paroladorita”) where user=’root’;
flush privileges;
quit
/usr/local/etc/rc.d/mysql-server stop
/usr/local/etc/rc.d/mysql-server start

Se poate testa astfel:

mysql -u root -p

Se poate verifica astfel:

grant all on *.* to root@’%’ identified by “paroladorita”;

Lasă un comentariu