Mysql Password reset
Zur Navigation springen
Zur Suche springen
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