forege database

@Tray2 thank you for replying

I am here .env I typed correctly DB_USERNAME DB_PASSWORD but was rejected

I don't know how to properly spot the problem

@Tray2 forge and tableplus connection is normal use sshkey

@o227786060@gmail.com I still don't understand what exactly the problem you are facing is?

However you usually on a production server disable remote access with the root user, and rather use a user that only has access to the database that the application uses.

@o227786060@gmail.com if I understand you correctly, you need to open a connection to your server that laravel can use. This is called a reverse shell

Example:

ssh -fNL 3305:localhost:3306 [email protected]

This will allow laravel to connect on localhost (or 127.0.0.1) port 3305

Be aware that you need to rerun this command after your computer restarts

@Tray2 yes ikonw! i try SSH Tunnel for MySQL Remote Access but still doesn't work.....

@o227786060@gmail.com so you cannot ssh into your forge server at all?

@Sinnbeck robert@liuzhanfude-MacBook-Pro ~ % ssh [email protected] -L 3306:127.0.0.1:3306 -N Enter passphrase for key '/Users/robert/.ssh/id_rsa': bind [127.0.0.1]:3306: Address already in use

seems to be successful but the local But still can't get in

@o227786060@gmail.com you are trying to use 3306 locally which is already in use. Use another port locally. I suggested 3305 earlier

@Sinnbeck When I execute the following command mysqlsh --host=127.0.0.1 --port=3306 -u forge -p

still fails... ERROR 1045 (28000): Access denied for user 'forge'@'localhost' (using password: NO)

@Sinnbeck robert@liuzhanfude-MacBook-Pro ~ % ssh [email protected] -L 3305:127.0.0.1:3306 -N Enter passphrase for key '/Users/robert/.ssh/id_rsa': bind [127.0.0.1]:3305: Address already in use channel_setup_fwd_listener_tcpip: cannot listen to port: 3305 Could not request local forwarding. is this correct?

@o227786060@gmail.com I don't know that command so I can't really help with it. This one that I suggested earlier is just regular ssh but with a tunnel

ssh -fNL 3305:localhost:3306 [email protected]

It is the same as just (but without the tunnel)

ssh [email protected]

@Sinnbeck robert@liuzhanfude-MacBook-Pro ~ % ssh -fNL 3305:localhost:3306 [email protected] Enter passphrase for key '/Users/robert/.ssh/id_rsa': robert@liuzhanfude-MacBook-Pro ~ % ssh [email protected]

Enter passphrase for key '/Users/robert/.ssh/id_rsa': Welcome to Ubuntu 20.04 LTS (GNU/Linux 5.4.0-1009-aws x86_64)

• Documentation: https://help.ubuntu.com
• Management: https://landscape.canonical.com
• Support: https://ubuntu.com/advantage

System information as of Thu Sep 15 18:25:45 UTC 2022

System load: 0.0 Processes: 135 Usage of /: 26.3% of 19.32GB Users logged in: 0 Memory usage: 41% IPv4 address for ens5: 10.0.1.102 Swap usage: 1%

• Ubuntu Pro delivers the most comprehensive open source security and compliance features.

  https://ubuntu.com/aws/pro

70 updates can be applied immediately. 9 of these updates are standard security updates. To see these additional updates run: apt list --upgradable

New release '22.04.1 LTS' available. Run 'do-release-upgrade' to upgrade to it.

3 updates could not be installed automatically. For more details, see /var/log/unattended-upgrades/unattended-upgrades.log

*** System restart required *** Last login: Thu Sep 15 18:13:40 2022 from 223.140.137.232 forge@clean-cloud:~$

How do I get data into this database?

@o227786060@gmail.com so it sounds like it ran successfully? No errors. You can how connect to the database on localhost on port 3305. Put it in laravels env and it should work

@Sinnbeck I appreciate your patience *100

@o227786060@gmail.com happy to help :)

@o227786060@gmail.com and localhost yes 👍

@Sinnbeck ok i try thanks