wok annotate mysql/stuff/reset-password.sh @ rev 22040
updated tokyocabinet and tokyocabinet-dev (1.4.32 -> 1.4.48)
| author | Hans-G?nter Theisgen |
|---|---|
| date | Mon Oct 21 17:24:12 2019 +0100 (2019-10-21) |
| 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 |