Mysql Password reset

Stoppen mysql

• systemctl stop mysql

Socket Verzeichnis anlegen

• test -d /var/run/mysqld/mysqld.sock || mkdir -m 777 /var/run/mysqld/mysqld.sock

Start

• mysqld_safe --skip-grant-tables --skip-networking &

Einlogen

• mysql -u root

In Mysql

• • use mysql;

dann entweder

• • update user set authentication_string=password('1111') where user='root';

oder

• • update user set password=password('1111') where user='root';

weiter

• • flush privileges;
  • exit

Stop

• killall mysqld

Start mysql

• systemctl start mysql