MySQL Database Query Builder Question

[docmann]

Hello Xavier,
Actually there is a link directly from the main phpMyAdmin page where
you can check and or change the status (assuming you have the right
access privilages).

I know that on our LAN, I cannot connect from a remote work station
without changing the "Host" settings....

HTH,
-Doc-

On 4/28/05, xbury.cs at clearstream.com <xbury.cs at clearstream.com> wrote:
>  
> Doc, 
>  
> Is this in the config.php file or? 
>  
> cheers 
> Xavier 
> 
>  
> On 28.04.2005 11:32:00 use-revolution-bounces wrote:
>  >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-re 
> 
> ________________________________
> 
> 
>  
> 
>  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