mysql密码修改脚本怎么写_mysql密码修改脚本编写与执行方法

#!/bin/bash
<h1>配置变量</h1><p>MYSQL_USER="root"
OLD_PASSWORD="old_password"
NEW_PASSWORD="new_secure_password"</p><h1>使用mysqladmin修改密码（推荐方式）</h1><p>mysqladmin -u "$MYSQL_USER" -p"$OLD_PASSWORD" password "$NEW_PASSWORD"</p><p>if [ $? -eq 0 ]; then
echo "✅ MySQL密码已成功修改为新密码。"
else
echo "❌ 密码修改失败，请检查原密码或权限。"
exit 1
fi

#!/bin/bash
<p>read -sp "请输入当前密码: " OLD_PASSWORD
echo
read -sp "请输入新密码: " NEW_PASSWORD
echo
read -sp "再次输入新密码: " CONFIRM_PASSWORD
echo</p><p>if [ "$NEW_PASSWORD" != "$CONFIRM_PASSWORD" ]; then
echo "❌ 两次密码不一致，操作取消。"
exit 1
fi</p><p>mysqladmin -u root -p"$OLD_PASSWORD" password "$NEW_PASSWORD"</p>
                    <div class="aritcle_card">
                        <a class="aritcle_card_img" href="/ai/1463">
                            <img src="https://img.php.cn/upload/ai_manual/000/000/000/175680176337096.png" alt="图改改">
                        </a>
                        <div class="aritcle_card_info">
                            <a href="/ai/1463">图改改</a>
                            <p>在线修改图片文字</p>
                            <div class="">
                                <img src="/static/images/card_xiazai.png" alt="图改改">
                                <span>455</span>
                            </div>
                        </div>
                        <a href="/ai/1463" class="aritcle_card_btn">
                            <span>查看详情</span>
                            <img src="/static/images/cardxiayige-3.png" alt="图改改">
                        </a>
                    </div>
                <p>if [ $? -eq 0 ]; then
echo "✅ 密码修改成功！"
else
echo "❌ 修改失败，请检查账户信息或网络连接。"
exit 1
fi

chmod +x change_mysql_password.sh
./change_mysql_password.sh

mysql -u root -p"$OLD_PASSWORD" -e "ALTER USER 'root'@'localhost' IDENTIFIED BY '$NEW_PASSWORD';"