- service mysql stop (debian way — /etc/init.d/mysql stop)
- mysqld_safe —skip-grant-tables & (debian way — /usr/bin/mysqld_safe)
- mysql -u root
- UPDATE mysql.user SET Password=PASSWORD(‘PASS12345′) WHERE User=’root’;
- FLUSH PRIVILEGES;
- GRANT ALL PRIVILEGES ON *.* TO ‘root’@’localhost’ IDENTIFIED BY ‘PASS12345’ WITH GRANT OPTION;
- exit
- service mysqld stop
- service mysqld start
- mysql -u root -p
- PASS12345
Указать новый пароль для панели Vesta CP:
/root/.my.cnf
/usr/local/vesta/conf/mysql.conf
kupereal недавно публиковал (посмотреть все)