[DiscordArchive] anyone have any info on importing the sql file updates?
[DiscordArchive] anyone have any info on importing the sql file updates?
Original source
cant seem to connect
![[Image: image.png?ex=690c207c&is=690acefc&hm=400...59de65fdd&]](https://cdn.discordapp.com/attachments/284406375495368704/1120929539908976731/image.png?ex=690c207c&is=690acefc&hm=40000c78bb3ce4bf81906c858de5b9c72c204a94c95847aab2685d559de65fdd&)
rektbyfaith
06-21-2023, 04:13 AM #11Archived author: Woodsjail • Posted: 2023-06-21T04:13:48.227000+00:00
Original source
cant seem to connect
Original source
By default MySQL is not publicly available
rektbyfaith
06-21-2023, 04:31 AM #12Archived author: 0xCiBeR • Posted: 2023-06-21T04:31:14.364000+00:00
Original source
By default MySQL is not publicly available
Original source
You need to edit mysql server config to bind to 0.0.0.0
rektbyfaith
06-21-2023, 04:31 AM #13Archived author: 0xCiBeR • Posted: 2023-06-21T04:31:33.195000+00:00
Original source
You need to edit mysql server config to bind to 0.0.0.0
Original source
And grant perms to the user from external ip
rektbyfaith
06-21-2023, 04:31 AM #14Archived author: 0xCiBeR • Posted: 2023-06-21T04:31:45.073000+00:00
Original source
And grant perms to the user from external ip
Original source
It’s probably easier to just download the file on the server and use the command line MySQL client
rektbyfaith
06-21-2023, 04:32 AM #15Archived author: 0xCiBeR • Posted: 2023-06-21T04:32:12.102000+00:00
Original source
It’s probably easier to just download the file on the server and use the command line MySQL client
Original source
```mysql -u username -p database_name < file.sql```
rektbyfaith
06-21-2023, 04:33 AM #16Archived author: 0xCiBeR • Posted: 2023-06-21T04:33:38.325000+00:00
Original source
```mysql -u username -p database_name < file.sql```
Original source
Or just add the file to the custom sql updates folder in the core and it will be applied when you launch the server
rektbyfaith
06-21-2023, 04:34 AM #17Archived author: 0xCiBeR • Posted: 2023-06-21T04:34:13.006000+00:00
Original source
Or just add the file to the custom sql updates folder in the core and it will be applied when you launch the server
Original source
thanks, i also found this -https://www.linode.com/docs/guides/create-an-ssh-tunnel-for-mysql-remote-access/
[Embed: Create an SSH Tunnel for MySQL Remote Access]
This guide will show you how to gain remote access to your MySQL server and database through PuTTY or similar mysql-client using an SSH Tunnel.
https://www.linode.com/docs/guides/creat...te-access/
rektbyfaith
06-21-2023, 04:43 AM #18Archived author: Woodsjail • Posted: 2023-06-21T04:43:24.150000+00:00
Original source
thanks, i also found this -https://www.linode.com/docs/guides/create-an-ssh-tunnel-for-mysql-remote-access/
[Embed: Create an SSH Tunnel for MySQL Remote Access]
This guide will show you how to gain remote access to your MySQL server and database through PuTTY or similar mysql-client using an SSH Tunnel.
https://www.linode.com/docs/guides/creat...te-access/
Original source
where is that folder?
![[Image: image.png?ex=690c27c2&is=690ad642&hm=bb8...39a278303&]](https://cdn.discordapp.com/attachments/284406375495368704/1120937351011639346/image.png?ex=690c27c2&is=690ad642&hm=bb89fa473c71f227879d90cd1b3879dd60780bacc281e63643d296e39a278303&)
rektbyfaith
06-21-2023, 04:44 AM #19Archived author: Woodsjail • Posted: 2023-06-21T04:44:50.554000+00:00
Original source
where is that folder?
Original source
i think im good
rektbyfaith
06-21-2023, 05:06 AM #20Archived author: Woodsjail • Posted: 2023-06-21T05:06:14.381000+00:00
Original source
i think im good