MySQL Database Query Builder Question

[docmann]

Hello Martin,
It's a long shot, but there is one more thing to check before giving up...

Using PhpMyAdmin, have a look at the "privilages" that are set up for
your DB and make sure it is set to "% any", which will allow access
from any domain address.

-Doc-

On 4/28/05, Martin McCarrick <martin.mccarrick at btinternet.com> wrote:
> Xavier
> 
> Oneandone.co.uk use call centre's in the far east, it's not a pleasant
> experience trying to simply understand what they are saying, imagine trying
> to negotiate!!
> 
> It's a bit flippant I know but my nerve's have been taken to the limit with
> call centre's. I would love to speak to an English speaking person who I can
> understand & who isn't simply referencing a FAQ (that I've already studied)
> to provide answers.
> 
> I think id like to simply change ISP (out the frying pan!)
> 
> Thanks for your help
> 
> Martin
> 
> 
> -----Original Message-----
> From: use-revolution-bounces at lists.runrev.com
> [mailto:use-revolution-bounces at lists.runrev.com] On Behalf Of
> xbury.cs at clearstream.com
> Sent: 28 April 2005 09:18
> To: How to use Revolution
> Subject: RE: MySQL Database Query Builder Question
> 
> Martin,
> 
> Later I'll be trying to drive the phpmyadmin post and gets to make it run
> but as you imagine it's not very efficient. However i dont really need a
> "live" access to it...
> 
> Have you tried negotiating with the ISP for it?
> 
> cheers
> Xavier
> 
> On 28.04.2005 10:06:43 use-revolution-bounces wrote:
> >Thanks Sarah & Xavier
> >
> >With PHP 3306 is the port used, I tried changing to
> 'oneandone.co.uk:port'
> >with many variations, to no avail.
> >
> >It seems that Xavier hit the nail on the head, my ISP wont allow this
> type
> >of access!!
> >
> >I really cant see the point of having a database that I cant access.
> >
> >Can anyone recommend a good ISP with 'proper' database hosting (MySQL
> >PHP
> >etc...)
> >
> >Regards
> >
> >
> >Martin McCarrick
> >
> >
> >
> >
> >-----Original Message-----
> >From: use-revolution-bounces at lists.runrev.com
> >[mailto:use-revolution-bounces at lists.runrev.com] On Behalf Of Sarah
> Reichelt
> >Sent: 28 April 2005 05:00
> >To: How to use Revolution
> >Subject: Re: MySQL Database Query Builder Question
> >
> >Hi Martin,
> >
> >> I'm trying to connect to my database which is hosted by
> >> oneandone.co.uk. I'm using the database query builder in RR.
> >>
> >> I set the name (Contact),
> >> host (db141.oneandone.co.uk) - this is the actual server name
> >> Database (dbxxxxxxxx), User (dboxxxxxxxx) Password (xxxxxxxx)
> >>
> >> When I try to press the connect button I get an error "Unknown MySQL
> >> Host 'db141.oneandone.co.uk' (11004)'
> >>
> >> I am able to connect to the database in PHP MyAdmin without any
> >> problems!
> >>
> >> The only thing I can think of that could be causing this is the
> >> syntax of the host name!! maybe I'm wrong, has anyone had this problem?
> >>
> >When I tried to find the IP address for "db141.oneandone.co.uk", I got
> >nothing. However I was able to get an address for "oneandone.co.uk"
> >using the hostNameToAddress() function.
> >
> >If the Rev database query builder uses the hostNameToAddress function
> before
> >trying to connect, it isn't going to work for the host name you have
> >supplied. What happens if you use just "oneandone.co.uk"?
> >
> >When you connect using PHP, does it use the standard MySQL port (3306)?
> >If not, you need to add this to the host name e.g.
> >oneandone.co.uk:12345 where 12345 is my imaginary port number.
> >
> >HTH,
> >Sarah
> >
> >_______________________________________________
> >use-revolution mailing list
> >use-revolution at lists.runrev.com
> >http://lists.runrev.com/mailman/listinfo/use-revolution
> >
> >
> >_______________________________________________
> >use-revolution mailing list
> >use-revolution at lists.runrev.com
> >http://lists.runrev.com/mailman/listinfo/use-revolution
> 
> -----------------------------------------
> Visit us at http://www.clearstream.com
> IMPORTANT MESSAGE    Internet communications are not secure and therefore
> Clearstream International does not accept legal responsibility for the
> contents of this message.    The information contained in this e-mail is
> confidential and may be legally privileged. It is intended solely for the
> addressee. If you are not the intended recipient, any disclosure, copying,
> distribution or any action taken or omitted to be taken in reliance on it,
> is prohibited and may be unlawful. Any views expressed in this e-mail are
> those of the individual sender, except where the sender specifically states
> them to be the views of Clearstream International or of any of its
> affiliates or subsidiaries.    END OF DISCLAIMER
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
> 
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>