Accessing a SQL database remotely

Hi everyone am a novice in the computer world. so go easy on me as am learning the ropes. I have a small ERP running a pharmacy using a sql database. what i wold like to know if i can install the program on my laptop and access the database remotely through the internet or other means and how.

 

You can use something like navicat. You would need to allow external access to the database, but you should be able to access from anywhere.

 

It may not be that easy if you are hosting the ERP system locally which connects to the internet through a dynamic ip. But if you have a dedicated ip on the server you have the database on and can open the port to it on your firewall and grant access to access from the remote ip or * [all ips] then you can use navicat to connect to it.

 

You want to access a Pharmacy's database and you're not using it at their site? hmmm, that question sounds a little shadey.
If it's not , no offense but it sounds like = 'I have a laptop and want to access Fort Knox Database, can anyone tell me what program to use and if it's possible'

 

Use Team Viewer and connect through VPN connection. It will take your remote server just like local server.

 

Hi,

If you have a MySQL database then you can use tools like MySQL-Front, SQL-Yog, Navicat etc.
If you have a MSSQL database then you can use SQL Server Management Studio to connect remotely.

To connect a database remotely you need following things :

1] IP address of database server
2] Database name, user name and its password
3] Database service port (some times some hosting provider change the default port for security reasons)
4] Remote connections should be enabled on database server
5] External connections for database service should be enabled in firewall
6] Your database user should have access permissions on database
7] If they have any restrictions on connections then your IP should have added in the white list of connections

 

There are all sorts of ways to do this (assuming that you have the legal right to access the database).

You can write a program that runs on the site, giving you secure access (login, etc.) to the database.

You can connect to a shell account on the site and access the database using a program running on the site.

You can rujn a program on your laptop that accesses the database remotely.

Which way would be best for you depends on a few things, like what you need to do, what access you have to the site, what your capabilities are, etc.

 

I

Thank you, I am trying to connect through navicat, will keep you posted if i face any trouble.

 

While connecting the database using navicat, it is giving me error as shown in screenshot. I don;t know what should be the port no. Please suggest.

 

Try to connect to the site directly, or write an admin page that allows you to connect to the database, and only allow you to access the page. (Those are the ways it's almost always done - on almost every type of website.)

 

install the related software is a way you can try

 

ftp?

 

@zaqtroy
Your query is bit confusing , anyway let me explain from what I understand.
So you wanted to have a program / application on your laptop , but the database will be hosted somewhere else on a public hosting server & you wanted to connect to it , am I right?

If so , yes you can do it , provided the database server admin , provides you with access to their server with all privileges like ADD / UPDATE / DELETE etc,..
But server admins provide restricted or controlled access from outside world to avoid hackers hacking into their system
So please contact database server providers & they might help you.

Hope this helps !!