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: m.do.co/c/fafb...
2. Composer: getcomposer.or...
3. Certbot: certbot.eff.org
Gumroad .pdf with all code lines (CAD$3): socialdatascie...
Timeline:
00:10 Creating a DigitalOcean droplet m.do.co/c/fafb...
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 getcomposer.or...
30:00 starting with Certbot 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

[@alexrimui]

The video has really helped me from Kenya. Thank you.

[@PostdocLife]

Glad it was helpful!

[@LaTecnologiaEnTusManos]

Hi, I'm from de Dominican Republic and your video let me resolve one problems that a have in DigitalOcean, thank for all

[@tinaranathania]

1 year later, I did some minor adjustments but omg..you literally saved my life! This is my very first server setup so it was a bit scary for me. BUT WE DID IT 🥺💕💕 Thank you so muchhhh!

[@PostdocLife]

Great to hear! Thank you for watching!

[@bobross2404]

This is the video that finally worked for me. I had to do a few things differently, but now I have my first server setup. Thank you for the video!

[@PostdocLife]

Glad it helped! I made it specifically brute force, without anything too much like Docker etc. However, I should have done it with GitHub connection :) Some things are probably also different for Ubuntu 22.04 (vs 20.04 in the video). I'll try to update whenever I'm deploying another Laravel website.

[@Magnomoy]

This is exactly what I have been looking for, Thank you!

[@PostdocLife]

Thanks. Glad I could help!

[@alvinellavu9603]

i've followed this tutorial all along and girl..... thank you soo much

[@PostdocLife]

you are welcome! glad it helped.

[@zhengen]

You are an angel, thanks a lot.

[@PostdocLife]

You're welcome!

[@Borma425]

Really This Video is Helpful . thanks

[@PostdocLife]

*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_

[@goondanjang]

can you make part 2 on how to setup subdomain routing on digital ocean with laravel ?

[@PostdocLife]

Hey, thanks for watching! I have never used subdomains :), but if I will use them, I'll make one!

[@shannonkendi166]

Not all my laravel files got copied . How do I resolve this?

[@PostdocLife]

it's probably the hidden files? try scp -rp [source]/. [user-name]@[IPaddress-server]:[destination]/