Connecting to a database which is on another server for laravel application

bhanu

12/14/22, 4:29 PM

I am trying to connect a database which is on an openlitespeed digital ocean droplet. Now I have created a new database using phpmyadmin. And I want to use this database for my laravel app which I deployed using there Apps platfrom.

The issue is in connection to the database. On table plus when I use the following credentials

server has the IP address of my openlitespeed server. This works.

But when I use this.

Again the Host has my Openlitspeed server ID it says 'Can't connect to the MYSQL server on 'my-ip'(10060)

This command netstat -tlnp returns

Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 127.0.0.1:3306          0.0.0.0:*               LISTEN      23749/mysqld
tcp        0      0 127.0.0.1:6379          0.0.0.0:*               LISTEN      1004/redis-server 1
tcp        0      0 0.0.0.0:80              0.0.0.0:*               LISTEN      3491/openlitespeed
tcp        0      0 127.0.0.53:53           0.0.0.0:*               LISTEN      18201/systemd-resol
tcp        0      0 0.0.0.0:22              0.0.0.0:*               LISTEN      13183/sshd
tcp        0      0 0.0.0.0:8088            0.0.0.0:*               LISTEN      3491/openlitespeed
tcp        0      0 0.0.0.0:25              0.0.0.0:*               LISTEN      1321/master
tcp        0      0 0.0.0.0:443             0.0.0.0:*               LISTEN      3491/openlitespeed
tcp        0      0 0.0.0.0:7080            0.0.0.0:*               LISTEN      3491/openlitespeed
tcp6       0      0 ::1:6379                :::*                    LISTEN      1004/redis-server 1
tcp6       0      0 :::22                   :::*                    LISTEN      13183/sshd
tcp6       0      0 :::25                   :::*                    LISTEN      1321/master

I need the 2nd method to work so that I can set following environment variable.

DB_CONNECTION=mysql
DB_HOST=
DB_PORT=
DB_DATABASE=project-qualification
DB_USERNAME=
DB_PASSWORD=

268

0 + 0

mysql

database

Elon Musk

I sit in a Tesla and translated this thread with Ai:

EN: Connecting to a database which is on another server for laravel application

TH: การเชื่อมต่อกับฐานข้อมูลซึ่งอยู่บนเซิร์ฟเวอร์อื่นสำหรับแอปพลิเคชัน laravel

RO: Conectarea la o bază de date care se află pe un alt server pentru aplicația laravel

RU: Подключение к базе данных, которая находится на другом сервере для приложения laravel

VI: Kết nối với cơ sở dữ liệu trên máy chủ khác cho ứng dụng laravel

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.