24 lines
741 B
Bash
24 lines
741 B
Bash
#!/usr/bin/env bash
|
|
|
|
export DEBIAN_FRONTEND="noninteractive"
|
|
|
|
# Upgrading system
|
|
apt update
|
|
apt upgrade -y
|
|
|
|
# Install Software
|
|
apt install -y mariadb-server htop iptstate iptables conntrack tcpdump
|
|
|
|
# Configure Software
|
|
sed -i -e "s@^bind-address =.*@bind-address = 0.0.0.0@g" /etc/mysql/mariadb.conf.d/50-server.cnf
|
|
|
|
systemctl restart mariadb.service
|
|
|
|
cat <<EOF | mysql
|
|
CREATE USER 'admin'@'localhost' IDENTIFIED BY 'gFrKmVjPr8WX3kDK4X8Phw4vSZkQnRk4gT9QWqGs';
|
|
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
|
|
CREATE USER 'admin'@'%' IDENTIFIED BY 'gFrKmVjPr8WX3kDK4X8Phw4vSZkQnRk4gT9QWqGs';
|
|
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION;
|
|
SHOW GRANTS FOR admin;
|
|
FLUSH PRIVILEGES;
|
|
EOF |