TASIOMIND.DEV — OPERATIONAL▸▸▸FULL STACK DEVELOPER @ GWQ SERVICEPLUS AG▸▸▸FOUNDER — K8SGPT.AI▸▸▸OPEN SOURCE: ACTIVE▸▸▸DISTRIBUTED SYSTEMS / KUBERNETES / AI▸▸▸RUST + GO + PYTHON▸▸▸FIELD TESTED / STATUS — NOMINAL▸▸▸LOCATION: EUROPE/BERLIN▸▸▸TASIOMIND.DEV — OPERATIONAL▸▸▸FULL STACK DEVELOPER @ GWQ SERVICEPLUS AG▸▸▸FOUNDER — K8SGPT.AI▸▸▸OPEN SOURCE: ACTIVE▸▸▸DISTRIBUTED SYSTEMS / KUBERNETES / AI▸▸▸RUST + GO + PYTHON▸▸▸FIELD TESTED / STATUS — NOMINAL▸▸▸LOCATION: EUROPE/BERLIN▸▸▸
← databases

Reset MySQL root password on Linux

July 4, 2017

Kurzablauf fuer MySQL 5.7/8.x. Nur lokal und mit Vorsicht.

1) MySQL stoppen

code
sudo systemctl stop mysql

2) Safe Mode starten

code
sudo mysqld_safe --skip-grant-tables &

3) Passwort setzen

code
mysql -u root

MySQL 8:

code
ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';
FLUSH PRIVILEGES;

MySQL 5.7:

code
UPDATE mysql.user SET authentication_string=PASSWORD('NewPassword')
WHERE user='root';
FLUSH PRIVILEGES;

4) Neustart

code
sudo systemctl restart mysql

Typische Fehler

  • Socket fehlt: /var/run/mysqld/mysqld.sock anlegen
  • authentication_string vs. password in MySQL 5.7+