wilhelms reset mysql passwd script
from the gentoo forums thread:
http://forums.gentoo.org/viewtopic.php?t=153453
i found it, liked id (cf ‘plain text’: use chmod dude), today i searched for it again. thats why i copied it to this blog now. very handy little skript that does no harm if you know how to use it:)
#!/bin/bash
#
# resetRootPass script
#
# Recover lost root password of mysql database.
#
# By Willem Bermon
#
echo
echo “Mysql password recovery utility”
echo
# Stop the mysql server
/etc/init.d/mysql stop
/etc/init.d/mysql zap > /dev/null
/bin/killall mysqld > /dev/null
# Run mysqld in permissionless mode
/sbin/start-stop-daemon –start –quiet –exec /usr/bin/mysqld_safe \
–background — –skip-grant-tables >/dev/null 2>&1
sleep 1
# Execute queries
mysql -u root mysql -e “UPDATE user SET Password=PASSWORD(‘$1′) WHERE \
user=’root’; \
FLUSH PRIVILEGES;”
if [[ $? -eq 0 ]]
then
echo ” ** SQL root password updated”
else
echo ” ** SQL root password update unsuccesful”
fi
# Restart the mysql server
/bin/killall mysqld > /dev/null
/etc/init.d/mysql start
echo “Succesfully updated password!!”
echo
echo
exit 0