Spaces:
Running
Running
| #!/bin/bash | |
| # MySQL setup script | |
| sudo apt-get update | |
| sudo apt-get install -y mysql-server | |
| # Secure installation | |
| sudo mysql_secure_installation | |
| # Create database and user | |
| sudo mysql -u root <<EOF | |
| CREATE DATABASE mydb; | |
| CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword'; | |
| GRANT ALL PRIVILEGES ON mydb.* TO 'myuser'@'localhost'; | |
| FLUSH PRIVILEGES; | |
| EOF | |