Mysql root-passwort reset

Submitted by Gast (nicht überprüft) on So, 12/02/2018 - 14:43

Mysql und Mysqld stoppen:

sudo /etc/init.d/mysql stop

sudo /etc/init.d/mysqld stop


Mysql_safe starten:

sudo mysqld_safe --skip-grant-tables & mysql -u root


Passwort aktualisieren:

use mysql;

update user set password=PASSWORD("mynewpassword") where User='root';

flush privileges;



Mysql und Mysqld neustarten:

sudo /etc/init.d/mysql stop

sudo /etc/init.d/mysql start

sudo /etc/init.d/mysqld stop

sudo /etc/init.d/mysqld start


Mit neuem Passwort als root einloggen:

mysql -u root -p 






















Neuen Kommentar schreiben

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.