Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/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
Add Comment
Please, Sign In to add comment