DEPLOY a LARAVEL app with MySQL database on DIGITALOCEAN (Ubuntu 20.04)

 

This video will explain how to deploy a laravel app with mysql database. Some things you will need: 1. DigitalOcean (affiliate link) --- get $200 to start: https://m.do.co/c/fafb872e3d2d 2. Composer: https://getcomposer.org/download/ 3. Certbot: https://certbot.eff.org Gumroad .pdf with all code lines (CAD$3): https://socialdatascientist.gumroad.com/l/yitsqi Timeline: 00:10 Creating a DigitalOcean droplet https://m.do.co/c/fafb872e3d2d 01:58 creating another (not root) user on Ubuntu server 05:50 Installing and configuring the firewall (UFW) 10:22 Copying mysql database into .sql file in phpmyadmin 13:29 Setting up MySQL on the server 17:50 Installing Composer https://getcomposer.org/download/ 30:00 starting with Certbot https://certbot.eff.org 31:46 Configuring DNS in Google Domains Some alterations: - don't use sudo mysql_secure_installation, instead log into mysql and use: alter user 'root'@'localhost' identified with mysql_native_password by 'yourpassword'; - use the following instead in laravel.conf: RewriteCond %{HTTPS} off You might also need to: - uncomment the following in the php.ini: extension=pdo_mysql - install php-mysql: (make sure it suggests the right php version like php8.1-mysql) sudo apt-get install php-mysql