Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- apt update
- apt -y dist-upgrade
- apt -y install mariadb-server mariadb-client
- read -p "Geben sie die Zahl der Schueler an: " anzahl_schueler
- pass="fbs"
- for (( zaehler=1; zaehler<=$anzahl_schueler; zaehler++))
- do
- username="schueler$zaehler"
- echo "$username"
- useradd -m -s /bin/bash "$username"
- echo "$username:$pass" | chpasswd
- echo "Lege Datenbank $username an!"
- mysql -u root -pfbsfbs -e "CREATE DATABASE ${username};"
- mysql -u root -pfbsfbs -e "CREATE USER ${username}@localhost IDENTIFIED BY '${pass}';"
- mysql -u root -pfbsfbs -e "GRANT ALL PRIVILEGES ON ${username}.* TO '${username}'@'localhost';"
- mysql -u root -pfbsfbs -e "FLUSH PRIVILEGES;"
- done
- exit 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement