четверг, 4 декабря 2025 г.

MySQL сброс пароля

> sudo /usr/local/mysql/support-files/mysql.server stop

> sudo /usr/local/mysql/support-files/mysql.server start --skip-grant-tables

> /usr/local/mysql/bin/mysql

mysql > ALTER USER 'root@localhost' IDENTIFIED BY 'MyNewPass';

mysql > exit or Ctrl + Z

> sudo /usr/local/support-files/mysql.server stop

> sudo /usr/local/support-files/mysql.server start

> mysql -u root -p

> Enter the new password

Источник: https://m.youtube.com/watch?v=OEXPj8iYP3c