Level 102
So the website is in the cloud and the mysql server is on your local computer?
1 like
Dec 27, 2021
11
Level 1
Problem connecting laravel with mysql database in xampp on AWS EC2 Ubuntu 20.4
Hi, I am new to laravel and still learning. I am working on ubuntu on aws. I tried to connect my application to the mysql database which I installed with xampp. I am using laravel 8.76.2
I got this error when DB_HOST=localhost in my .env file:
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from Contact)
and when I put DB_HOST=127.0.0.1 I got this error:
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from Contact)
I am running laravel appplication on nginx server on my aws public IP! can anyone help me in this regards?
Level 1
@Sinnbeck no sir, both are on cloud. I installed xampp on aws and made it accessible through the public ip of my instance.
Level 102
from the official faq
XAMPP is not meant for production use but only for development environments.
Level 102
you might want to ask support to have your nickname whitelisted. It isn't possible to tag you as your name is considered spam
Level 1
@Sinnbeck sir I am new to Laravel and laracast forums... Why is my name spam?
Level 102
I don't know. But if I try and tag you I get a spam message. Try tagging yourself
Level 73
It's extremly dangerous running anything but dev on xampp, I would say that it is for dev as well, but that is just your local computer that hopefully is protected by a properly set up firewall.
I recommend that you use a deploy tool like Ploi.
If you still want to do it manually you can use this guide
https://www.howtoforge.com/tutorial/install-laravel-on-ubuntu-for-apache/
And to secure MySql se step two of this guide
https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-ubuntu-20-04
1 like
Please or to participate in this conversation.