MySQL Database Query Builder Question

Thu Apr 28 06:23:55 EDT 2005

Hi Docmann

It seems that I cant even use phpAdmin anymore....I have it installed (v
2.3.2) on my site but cant access it anymore as I would normally, the link I
had saved in favourites does nothing now! Not good.

Oneandone.co.uk now have a MySQL admin link from within their own web
control panel which utilises phpMyadmin 2.6.1, in it there is no access to
privileges.

I think they have restricted access in favour of me 'upgrading' by the look
of it.

Martin

-----Original Message-----
From: use-revolution-bounces at lists.runrev.com
[mailto:use-revolution-bounces at lists.runrev.com] On Behalf Of docmann
Sent: 28 April 2005 10:49
To: xbury.cs at clearstream.com
Cc: How to use Revolution
Subject: Re: MySQL Database Query Builder Question

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
_______________________________________________
use-revolution mailing list
use-revolution at lists.runrev.com
http://lists.runrev.com/mailman/listinfo/use-revolution