Two questions in one:
1.
I thought I would be able to use my M$ Access Front-End as an app to access a hosted MySQL server through port 3306. Now, I am reading stuff on the web about how 3306 should not be open and if it is, the ISP is doing a no-no. Is that the same "open" as I would need to have an application access MySQL?
Is there a secure method for an app to access a MySQL database? I read an article where SSH may be a good answer. Anyone?
2.
I have a proxy server at work to get out to the internet. I want to be able to use phpmyadmin or MySQL administrator to manage my hosted MySQL database. How do I configure them to provide the firewall with user/password information?
Also, if I am able to manage from work/ home, does that mean port 3306 is open (or too open?)?
Thanks. Sean.
1.
I thought I would be able to use my M$ Access Front-End as an app to access a hosted MySQL server through port 3306. Now, I am reading stuff on the web about how 3306 should not be open and if it is, the ISP is doing a no-no. Is that the same "open" as I would need to have an application access MySQL?
Is there a secure method for an app to access a MySQL database? I read an article where SSH may be a good answer. Anyone?
2.
I have a proxy server at work to get out to the internet. I want to be able to use phpmyadmin or MySQL administrator to manage my hosted MySQL database. How do I configure them to provide the firewall with user/password information?
Also, if I am able to manage from work/ home, does that mean port 3306 is open (or too open?)?
Thanks. Sean.