mysql数据库密码生成器_有大佬知道怎么修改数据库密码，和数据库密码生成器吗。...

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

#!/bin/bash

PORT="3306"

USERNAME="root"

PASSWORD="88888888"

DBNAME="d_taiwan"

DBNAME2="mysql"

delete="delete from user where User='root'"

altergame="update user set password=password('新密码') where user='game'"

update="update db_connect set db_passwd='新密码对应的生成码' where db_passwd='20e35501e56fcedbe8b10c1f8bc3595be8b10c1f8bc3595b'"

refresh="flush privileges"

mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${update}"

mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME2} -e "${altergame}"

mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME2} -e "${delete}"

mysql -h${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} ${DBNAME} -e "${refresh}"

sed -i "s/20e35501e56fcedbe8b10c1f8bc3595be8b10c1f8bc3595b/新密码对应的生成码/g" `find . -type f -name "*.tbl"`

sed -i "s/20e35501e56fcedbe8b10c1f8bc3595be8b10c1f8bc3595b/新密码对应的生成码/g" `find . -type f -name "*.cfg"`

把这个保存到一个文件，然后“bash 文件名”