wok annotate mysql/stuff/reset-password.sh @ rev 21355
updated libzip and libzip-dev (1.4.0 -> 1.5.2)
| author | Hans-Günter Theisgen |
|---|---|
| date | Sun Apr 21 08:42:08 2019 +0100 (2019-04-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 |