wok annotate mysql/stuff/reset-password.sh @ rev 24729
updated libdnet and libdnet-dev (1.12 -> 1.14)
author | Hans-G?nter Theisgen |
---|---|
date | Tue Mar 15 16:28:57 2022 +0100 (2022-03-15) |
parents | |
children |
rev | line source |
---|---|
pascal@19008 | 1 #!/bin/sh |
pascal@19008 | 2 |
pascal@19008 | 3 [ -z "$1" ] && echo "Usage: $0 <newpassword>" && exit 1 |
pascal@19008 | 4 |
pascal@19008 | 5 /etc/init.d/mysql stop |
pascal@19008 | 6 /usr/bin/mysqld_safe --skip-grant-tables & |
pascal@19008 | 7 mysql <<EOT |
pascal@19008 | 8 UPDATE `mysql`.`user` SET `Password` = password('$1') WHERE `User` = "root" AND Host = "localhost"; |
pascal@19008 | 9 quit |
pascal@19008 | 10 EOT |
pascal@19008 | 11 mysqladmin shutdown |
pascal@19008 | 12 /etc/init.d/mysql start |