Mysql root-passwort reset

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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

MySQL

Neuen Kommentar schreiben

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

Suche

Neueste Kommentare