Ubuntu上にLaravel × MySQL × Apache環境を構築する

docker --version

docker pull ubuntu

docker images | grep ubuntu

docker run -it -d --name laravel -p 80:80 ubuntu

docker ps

docker exec -it laravel bash

apt update
apt install -y sudo curl vim lsof

apt install -y mysql-server

/etc/init.d/mysql status

/etc/init.d/mysql start

mysql_secure_installation

sudo mysql

mysql> CREATE USER 'username'@'host' IDENTIFIED BY 'password';

mysql> GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT ON *.* TO 'username'@'host';

mysql> FLUSH PRIVILEGES;
mysql> quit;

mysql -u username -p

CREATE DATABASE test_db;

apt install -y apache2

/etc/init.d/apache2 status

/etc/init.d/apache2 start

vim /etc/apache2/sites-available/000-default.conf

<VirtualHost *:80>
        # The ServerName directive sets the request scheme, hostname and port that
        # the server uses to identify itself. This is used when creating
        # redirection URLs. In the context of virtual hosts, the ServerName
        # specifies what hostname must appear in the request's Host: header to
        # match this virtual host. For the default virtual host (this file) this
        # value is not decisive as it is used as a last resort host regardless.
        # However, you must set it for any further virtual host explicitly.
        ServerName localhost

        ServerAdmin webmaster@localhost
        DocumentRoot /var/www/sample_app/public

        # Available loglevels: trace8, ..., trace1, debug, info, notice, warn,
        # error, crit, alert, emerg.
        # It is also possible to configure the loglevel for particular
        # modules, e.g.
        #LogLevel info ssl:warn

        ErrorLog ${APACHE_LOG_DIR}/error.log
        CustomLog ${APACHE_LOG_DIR}/access.log combined

        <Directory "/var/www/sample_app/public">
          Require all granted
          AllowOverride All
        </Directory>

        # For most configuration files from conf-available/, which are
        # enabled or disabled at a global level, it is possible to
        # include a line for only one particular virtual host. For example the
        # following line enables the CGI configuration for this host only
        # after it has been globally disabled with "a2disconf".
        #Include conf-available/serve-cgi-bin.conf
</VirtualHost>

apt install -y php php-common php-cli php-gd php-mysql php-curl php-intl php-mbstring php-bcmath php-xml php-zip

php -v

curl -sS <https://getcomposer.org/installer> | php -- --install-dir=/usr/bin --filename=composer

composer -V

cd /var/www

composer create-project --prefer-dist laravel/laravel sample_app

cd sample_app && chmod -R 777 storage

vim .env

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=test_db
DB_USERNAME=username
DB_PASSWORD=password

php artisan migrate