1
0
mirror of https://github.com/tommytran732/MariaDB-Root-Password-Reset synced 2024-06-19 01:37:30 -04:00
MariaDB-Root-Password-Reset/mariadb-103.sh
Tommy 1ade36ed4f
Add License notice
Signed-off-by: Tommy <contact@tommytran.io>
2023-12-06 22:41:35 -07:00

37 lines
1.1 KiB
Bash

#!/bin/bash
# Copyright (C) 2023 Thien Tran
#
# Licensed under the Apache License, Version 2.0 (the "License"); you may not
# use this file except in compliance with the License. You may obtain a copy of
# the License at
#
# http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
# WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
# License for the specific language governing permissions and limitations under
# the License.
output(){
echo -e '\e[36m'"$1"'\e[0m';
}
mariadb_root_reset(){
service mysql stop
mysqld_safe --skip-grant-tables >res 2>&1 &
sleep 5
rootpassword=$(/dev/urandom | tr -dc 'a-zA-Z0-9' | fold -w 32 | head -n 1)
Q1="UPDATE user SET plugin='';"
Q2="UPDATE user SET password=PASSWORD('$rootpassword') WHERE user='root';"
Q3="FLUSH PRIVILEGES;"
SQL="${Q1}${Q2}${Q3}"
mysql mysql -e "$SQL"
pkill mysqld
service mysql restart
output "Your MariaDB root password is $rootpassword"
}
mariadb_root_reset