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;

quit

 

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.