wok annotate mysql/stuff/reset-password.sh @ rev 21922

Add get-pcem-roms (again)
author Pascal Bellard <pascal.bellard@slitaz.org>
date Sat Oct 05 18:31:33 2019 +0200 (2019-10-05)
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