Posts

Showing posts with the label server

Protecting SQL Server for Private Usage

Protecting SQL Server for Private Usage So I have an issue. I have a server, lets call it (testserver.net). Right now, to change the database, from my application, my app runs "testserver.netadd.php". The problem is anyone can run that and change things in my database. How do I make it that needs some sort of verification before running the code in add.php so no one can just have access to my server? (Like a password or something). Let your application access the add.php with some secret tokens(make it a long string). if the token is not present with the request, deny access to the script file. – Shan Jul 2 at 5:45 3 Answers 3 create a token : 1MBASFDFACAUYTUG^%(!@UUIASNSR*_-+LASQWFVSA4QWYUI12670 ,save this token safel...

How can convert my PC to online server?

How can convert my PC to online server? I have made an android app that can connect to MySQL database via online server url. Now, I want to connect the app to MySQL database on my PC instead of the online server. I have searched the internet, and recommendations were to use No-IP software for Dynamic DNS and forward port 3306 in router's configuration page. then, use an online host like 000webhost.com, I have done all of this, but I still don't know how to link my PC to the free domain I acquired on the internet? the input to my android app should be like String ServerURL = "http://mydomain.000webhost.com/get_data.php" ; I have the get_data.php file on my PC, how can I connect it to the online host. Update thank you alexandre for your help. I opened port 80 on my PC inbound/outbound rules, and this is my NAT page in the router config. page, can you tell how should I fill these fields? 1 Answer 1 ...