Some partners of mine and I are writing a host-based application,
which would greatly benefit if we could take advantage of a web
services-like function we are formulating.
Unfortunately, this requires a centralized (or duplicated) MySQL
database which can be accessed via several web hosting providers.
In my experience, typically web hosting providers only allow localhost
access to MySQL databases.
Are there any providers who either allow remote access or does anyone
know of providers specifically designed for this function? I did find
one, but it is a "giveaway" when their product is purchased: http://www.navicat.com
So far, I'm on page 8 of my 110,000-item result from a Google search.
kai www.perfectreign.com || www.filesite.org
g2004 at g3prod.cotse.ne t 12 2857
"filesitegu y" <ab***@127.0.0. 1> wrote in message
news:co******** *************** *********@4ax.c om... Some partners of mine and I are writing a host-based application, which would greatly benefit if we could take advantage of a web services-like function we are formulating.
Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers.
In my experience, typically web hosting providers only allow localhost access to MySQL databases.
Are there any providers who either allow remote access or does anyone know of providers specifically designed for this function? I did find one, but it is a "giveaway" when their product is purchased: http://www.navicat.com
My host, www.lunarpages.com (use this link: http://secure.lunarpages.com/trackin...cgi?id=obsydi2) if
you want to sign up and give me affiliate credit), allows you to add as many
valid external hosts as you would like for remote access to the database. I
use that all the time to access my hosted database from my home test server.
For that matter, just about any host that uses a cPanel control panel will
probably do the same.
- Virgil
filesiteguy <ab***@127.0.0. 1> wrote in
news:co******** *************** *********@4ax.c om: Some partners of mine and I are writing a host-based application, which would greatly benefit if we could take advantage of a web services-like function we are formulating.
Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers.
In my experience, typically web hosting providers only allow localhost access to MySQL databases.
Are there any providers who either allow remote access or does anyone know of providers specifically designed for this function? I did find one, but it is a "giveaway" when their product is purchased: http://www.navicat.com
So far, I'm on page 8 of my 110,000-item result from a Google search.
kai www.perfectreign.com || www.filesite.org g2004 at g3prod.cotse.ne t
I don't know what your budget is, but you might consider renting a
dedicated server then you can do whatever you like. You will have root
access (full control). Now a days, you can find dedicated servers for less
than $60 per month. Granted, these are low end servers, but you would not
be sharing with other customers and the net effect might be better
performance than a shared hosting solution.
--
Edward Alfert http://www.rootmode.com/
Multiple Domain Hosting and Reseller Hosting Plans
Coupon Code (Recurring $5/month Discount): newsgroup
In article <co************ *************** *****@4ax.com>, ab***@127.0.0.1
says... Some partners of mine and I are writing a host-based application, which would greatly benefit if we could take advantage of a web services-like function we are formulating.
Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers.
In my experience, typically web hosting providers only allow localhost access to MySQL databases.
Are there any providers who either allow remote access or does anyone know of providers specifically designed for this function? I did find one, but it is a "giveaway" when their product is purchased: http://www.navicat.com
So far, I'm on page 8 of my 110,000-item result from a Google search.
Why not run a web service that has one web site query the other web site
for information - use some non-standard port.
--
-- sp*********@rro hio.com
(Remove 999 to reply to me)
In article <co************ *************** *****@4ax.com>, filesiteguy wrote: Some partners of mine and I are writing a host-based application, which would greatly benefit if we could take advantage of a web services-like function we are formulating.
Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers.
Meaby have a look at a better/more flexible rdbms that supports
replication?
Are there any providers who either allow remote access or does anyone know of providers specifically designed for this function? I did find one, but it is a "giveaway" when their product is purchased: http://www.navicat.com
You could do it yourself. But instead of using some obscure portnumber
do it the right way: set up a SSL tunnel between the mysql server and
the client and send all traffic through that tunnel.
--
Tim Van Wassenhove <http://home.mysth.be/~timvw>
Tim Van Wassenhove <eu**@pi.be> wrote: Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers.
Meaby have a look at a better/more flexible rdbms that supports replication?
What are you trying to say?
BTW mysql 4.x supports replication.
--
Daniel Tryba
I would suggest two solutions:
1. on the host where MySQL running you deploy a web based query
service. This can be fully implemented by php script, and can be
accessed from remote host.
2. I can provide you with a hosting plan at $240/year with following
features:
600M space, 10G bandwidth, unlimited pop account, unlimited
databases, and allow remote access (at your own risk:).
Alex Shi Some partners of mine and I are writing a host-based application, which would greatly benefit if we could take advantage of a web services-like function we are formulating.
Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers.
In my experience, typically web hosting providers only allow localhost access to MySQL databases.
Are there any providers who either allow remote access or does anyone know of providers specifically designed for this function? I did find one, but it is a "giveaway" when their product is purchased: http://www.navicat.com
So far, I'm on page 8 of my 110,000-item result from a Google search.
kai www.perfectreign.com || www.filesite.org g2004 at g3prod.cotse.ne t
Daniel Tryba wrote: Tim Van Wassenhove <eu**@pi.be> wrote: Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers.
Meaby have a look at a better/more flexible rdbms that supports replication?
What are you trying to say?
BTW mysql 4.x supports replication.
Actually all the way back to 3.23.15
--
MVH Jeppe Uhd - NX http://nx.dk
Webhosting for nørder og andet godtfolk
Jeppe Uhd wrote: Daniel Tryba wrote: Tim Van Wassenhove <eu**@pi.be> wrote: Unfortunately, this requires a centralized (or duplicated) MySQL database which can be accessed via several web hosting providers.
Meaby have a look at a better/more flexible rdbms that supports replication?
What are you trying to say?
BTW mysql 4.x supports replication.
Actually all the way back to 3.23.15
Yes but AFAICS its not a distributed database which I suspect is what K
needs.
The sugestion of using a php protocol wrapper to run the queries as if local
could be implemented fairly easily (I reckon about 60 lines of code) and
would be my bet as the easiest solution.
HTH
C.
Colin McKinnon <co************ **@andthis.mms3 .com> wrote: BTW mysql 4.x supports replication. Actually all the way back to 3.23.15
Yes but AFAICS its not a distributed database which I suspect is what K needs.
Master/master replication is in 4.1.x (which is not for production last
time I took al ook).
The sugestion of using a php protocol wrapper to run the queries as if local could be implemented fairly easily (I reckon about 60 lines of code) and would be my bet as the easiest solution.
Fastest and safest (networkwise, like http is almost always open or
available by proxy) solution indeed.
--
Daniel Tryba This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Mary Grace |
last post by:
I have been using MySQL for awhile, and for the first time someone from
outside our portable /16 needs access to some tables. We have given them
the server IP address, the dB name, the port 3306, the root username, and
the password, but they still can't get access. Of course, no firewalls or
other things in the way.
Is it true that MySQL defaults to local access only, and to enable remote
access you must do something unusual with...
|
by: Fred |
last post by:
I just started using MySQL, and cannot find how to
configure host access in the my.cnf file. I want
to be able to allow access to a MySQL database
from a remote host, and also from a particular
network. How do you configure access of this sort?
-Thanks
|
by: Ian Davies |
last post by:
Hello all
The following code allows me to connect to a local MySQL database on my pc
from a VB6 project.
****************************************************************************
**
Dim conn As ADODB.Connection
Dim cs As String
Dim MyServer As String
|
by: Greg Gursky |
last post by:
Hello:
I'm doing some planning on a potential project with which I need
some help. The database at the focus of this question is a
MS Access database that is currently accessed by DAO from a local
webserver. I need to access the same database remotely through
TCP/IP. There will be potentially many transactions coming from
both the web server and remotely, so the solution needs to keep
the data safe in such an environment. However,...
|
by: Ike |
last post by:
Let's say I have a MySQL 4.12 database, opened to the internet on
111.111.111.111 allowing all incoming and outgoing ports. I have a username
and password setup, which CAN connect to this database, from
222.222.222.222.
Also on 222.222.222.222, which is running Tomcat, I have a Java servlet,
called, say, servlet.class in WEB-INF/classes. servlet.class has permissions
755, as does WEB-INF/classes.
Additionally, I have on...
| |
by: Martin |
last post by:
Hi all.
I have a fully functional page hosted on my PC that uses PHP and
connects to MySQL on my PC to generate it's code.
I now have some web hosting available which includes both PHP and MySQL
support, however the webhost is still in the process of getting the
MySQL support activated and functional.
I therefore have uploaded my webpage to the host and edited the webpage
|
by: Jerim |
last post by:
I have a script on one server, trying to access the MySQL database on
another server. The server with the script is on an outside network,
hosted with another company. The MySQL server is here in the
office;behind a firewall. Script works fine when it is on the local
machine, but when I moved it to the offsite webserver it gives me:
Warning: mysql_connect() : Lost connection to
MySQL server during query in...
|
by: Kurt Jakobsen |
last post by:
Hello,
I have a client program that I use to access a MySql 5.0 community server. The client can be on the machine where the MySql server is installed or from a remote machine.
The client has worked fine for 1/2 a year from both the local machine and from remote. I installed the server in january. After returning from vacation in july, I cannot access the server from a remote machine anymore. But the client that is locally on the same...
|
by: Pseudonyme |
last post by:
A Paris
Le 14 Nv MMVII
Dear Madam and Sir,
Do you know how to access a MYSQL DB from an external server ?
We read the information and studied :
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |