#!/bin/bash
# Install MariaDB repository
sudo tee /etc/yum.repos.d/MariaDB.repo <<EOF
# MariaDB 10.6 CentOS repository list - created 2023-04-20 10:00 UTC
# [Conteúdo Oculto]
[mariadb]
name = MariaDB
baseurl = [Conteúdo Oculto]
gpgkey=[Conteúdo Oculto]
gpgcheck=1
EOF
# Install MariaDB 10.6
echo "Installing MariaDB 10.6..."
yum install -y mariadb-server
# Start MariaDB service
echo "Starting MariaDB service..."
systemctl start mariadb
# Check if MariaDB is running
if ! systemctl status mariadb &> /dev/null; then
echo "Failed to start MariaDB."
exit 1
fi
# Set a random password for MariaDB
password=$(openssl rand -base64 20)
echo "Generated password: $password"
# Save the password to a file
echo $password > ~/mariadb_password.txt
# Secure MariaDB installation
echo "Securing MariaDB installation..."
mysql -e "DELETE FROM mysql.user WHERE User='';"
mysql -e "DELETE FROM mysql.user WHERE User='root' AND Host NOT IN ('localhost', '127.0.0.1', '::1');"
mysql -e "DROP DATABASE IF EXISTS test;"
mysql -e "DELETE FROM mysql.db WHERE Db='test' OR Db='test\_%';"
mysql -e "FLUSH PRIVILEGES;"
mysql -e "ALTER USER 'root'@'localhost' IDENTIFIED BY '$password';"
echo "MariaDB installation complete."
.png.9bb9ea8e98774e663fd240aa7594c5c2.png)
.png)
