mysql 恢复忘记root密码脚本-centos

#!/bin/bash
newpassword=$1
if [ “$newpassword” == “” ];then
echo “password is emty. please use ./mysql_password_recovery.sh yourpassword”
exit
fi
echo ” Stopping mysql…”
systemctl stop mysqld
echo ” Setting the mySQL environment option..”
systemctl set-environment MYSQLD_OPTS=”–skip-grant-tables”
echo “Startng mysql ignoring password verification..”
systemctl start mysqld
echo “Updating the root user password with your provided password”
# mysql -u root
echo “UPDATE mysql.user SET authentication_string = PASSWORD(‘$newpassword’) WHERE User = ‘root’ AND Host = ‘localhost’;” | mysql -u root
echo “FLUSH PRIVILEGES;” | mysql -u root
#echo “quit” | mysql -u root
echo “Stopping mysql..”
systemctl stop mysqld
echo “Unsetting the mySQL envitroment option so it starts normally next time..”
systemctl unset-environment MYSQLD_OPTS
echo “Start mysql normally..”
systemctl start mysqld

echo “Try to login using your new password:”
mysql -u root -p

tmux quick usage

session management

tmux ls (or tmux list-sessions)
tmux new -s session-name
Ctrl-b d Detach from session
tmux attach -t [session name]
tmux kill-session -t session-name

Ctrl-b c Create new window
Ctrl-b d Detach current client
Ctrl-b l Move to previously selected window
Ctrl-b n Move to the next window
Ctrl-b p Move to the previous window
Ctrl-b & Kill the current window
Ctrl-b , Rename the current window
Ctrl-b q Show pane numbers (used to switch between panes)
Ctrl-b o Switch to the next pane
Ctrl-b ? List all keybindings

moving between windows

Ctrl-b n (Move to the next window)
Ctrl-b p (Move to the previous window)
Ctrl-b l (Move to the previously selected window)
Ctrl-b w (List all windows / window numbers)
Ctrl-b window number (Move to the specified window number, the
default bindings are from 0 — 9)

Tiling commands

Ctrl-b % (Split the window vertically)
CTRL-b ” (Split window horizontally)
Ctrl-b o (Goto next pane)
Ctrl-b q (Show pane numbers, when the numbers show up type the key to go to that pane)
Ctrl-b { (Move the current pane left)
Ctrl-b } (Move the current pane right)

Make a pane its own window

Ctrl-b : “break-pane”

add to ~/.tmux.conf

bind | split-window -h
bind – split-window -v