Сброс пароля mysql

17.01.2020 - Записи в блоге

# systemctl stop mysql
# mysqld_safe --skip-grant-tables &
# mysql
MariaDB [(none)]> UPDATE mysql.user SET Password=PASSWORD('vadimdenisov') WHERE User='root';
MariaDB [(none)]> FLUSH PRIVILEGES;
MariaDB [(none)]> exit;
# mysqladmin -u root -pvadimdenisov shutdown
# systemctl start mysql

 

› tags: mysql / reset / сброс /