Phpmyadmin access from internet

Discuss the phpMyAdmin Package Here.
Forum rules
Synology Community is the new platform for the enthusiasts' interaction, and it will soon be available to replace the Forum.
aaavin24
I'm New!
I'm New!
Posts: 6
Joined: Tue Jun 20, 2017 9:57 am

Phpmyadmin access from internet

Unread post by aaavin24 » Tue Jun 20, 2017 10:02 am

Hi,
I need to access my Phpmyadmin which is installed on my synology NAS from outside LAN. Can anybody please guide me the necessary steps needed to do that.
I need to create different database table for which I need access to my PHPmyadmin on internet.
Any help would be much appreciated
Thanks

User avatar
Rusty1281
Sagacious
Sagacious
Posts: 3238
Joined: Fri Jun 03, 2011 10:51 pm

Re: Phpmyadmin access from internet

Unread post by Rusty1281 » Tue Jun 20, 2017 12:05 pm

By default phpmyadmin is on port 80 hosted on your NAS. If you are comfortable exposing you NAS on port 80 (or any other port) on the internet then you need to forward that port on your router to gain access. Also you will need to setup firewall rule that will allow access to it (if you have setup fw in the 1st place) or use it to deny access on port 80 from specific domains/ips/countries.
Synology DS918+ (4x4TB WD RED - RAID 5 with 2x250GB 960EVO NVMe) | Synology DS412+ (4x3TB WD RED - RAID 5) | RT1900AC

aaavin24
I'm New!
I'm New!
Posts: 6
Joined: Tue Jun 20, 2017 9:57 am

Re: Phpmyadmin access from internet

Unread post by aaavin24 » Wed Jun 21, 2017 1:35 pm

Hi Rusty1281,
I do not have firewall . on internet I can see the phpmyadmin installed but I could not open it . Do you know why that is happening . I think I have done port forwarding for both phpmyadmin as Mysql.
I can even see the folder structure for phpmyadmin in www root folder but I need to open my phpmyadmin application outside my LAN which is not possible

User avatar
Rusty1281
Sagacious
Sagacious
Posts: 3238
Joined: Fri Jun 03, 2011 10:51 pm

Re: Phpmyadmin access from internet

Unread post by Rusty1281 » Wed Jun 21, 2017 1:51 pm

So on what url are your trying to access your phpadmin page? Can you give an example? Whats your public url that you are trying to use?

http://xxx.xxxx.xx/???
Synology DS918+ (4x4TB WD RED - RAID 5 with 2x250GB 960EVO NVMe) | Synology DS412+ (4x3TB WD RED - RAID 5) | RT1900AC

aaavin24
I'm New!
I'm New!
Posts: 6
Joined: Tue Jun 20, 2017 9:57 am

Re: Phpmyadmin access from internet

Unread post by aaavin24 » Thu Jun 22, 2017 9:13 am

Http://77.72.53.93 external and internal 192.168.1.130

User avatar
Rusty1281
Sagacious
Sagacious
Posts: 3238
Joined: Fri Jun 03, 2011 10:51 pm

Re: Phpmyadmin access from internet

Unread post by Rusty1281 » Thu Jun 22, 2017 10:01 pm

well have you tried to access it via a similar link: http://your_external_address/phpMyAdmin/ ?
Synology DS918+ (4x4TB WD RED - RAID 5 with 2x250GB 960EVO NVMe) | Synology DS412+ (4x3TB WD RED - RAID 5) | RT1900AC

aaavin24
I'm New!
I'm New!
Posts: 6
Joined: Tue Jun 20, 2017 9:57 am

Re: Phpmyadmin access from internet

Unread post by aaavin24 » Fri Jun 23, 2017 8:27 am

Yes I have tried it but unable to load the page through external

User avatar
Rusty1281
Sagacious
Sagacious
Posts: 3238
Joined: Fri Jun 03, 2011 10:51 pm

Re: Phpmyadmin access from internet

Unread post by Rusty1281 » Fri Jun 23, 2017 3:40 pm

Hawe you opened up a port on your router to allow access from the outside world?
Synology DS918+ (4x4TB WD RED - RAID 5 with 2x250GB 960EVO NVMe) | Synology DS412+ (4x3TB WD RED - RAID 5) | RT1900AC

aaavin24
I'm New!
I'm New!
Posts: 6
Joined: Tue Jun 20, 2017 9:57 am

Re: Phpmyadmin access from internet

Unread post by aaavin24 » Mon Jun 26, 2017 9:32 am

yes I have enabled all the port neccesary for External access . The mySQl port 3306 was missing which was also enabled so I am not sure what am I doing wrong.
Can you provide me all the steps to do I would reset and then try to do the settings again, if that could help me.
From basic step to the end

User avatar
Rusty1281
Sagacious
Sagacious
Posts: 3238
Joined: Fri Jun 03, 2011 10:51 pm

Re: Phpmyadmin access from internet

Unread post by Rusty1281 » Mon Jun 26, 2017 9:41 am

Well there isnt that much to explain. If you have forwarded ports and you access your php site via its public ip and/or its ddns that should work just fine.
Synology DS918+ (4x4TB WD RED - RAID 5 with 2x250GB 960EVO NVMe) | Synology DS412+ (4x3TB WD RED - RAID 5) | RT1900AC

aaavin24
I'm New!
I'm New!
Posts: 6
Joined: Tue Jun 20, 2017 9:57 am

Re: Phpmyadmin access from internet

Unread post by aaavin24 » Wed Jun 28, 2017 11:53 am

Hi
Port 80 was not forwarded on my router I found out when I was trying to make connection.Anyway is solved now thank Rusty1281 for your help

Post Reply

Return to “phpMyAdmin”