wok annotate mysql/stuff/reset-password.sh @ rev 24902
Update some web_site
| author | Pascal Bellard <pascal.bellard@slitaz.org> |
|---|---|
| date | Sat Apr 09 09:39:20 2022 +0000 (2022-04-09) |
| 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 |