MySQL Database Query Builder Question

[docmann]

As an afterthought, I'd highly recommend that you have a good look at
the mySQL documentation in regards to security settings. It would be a
good thing to understand the issues *before* making changes. :)

-Doc-

On 4/28/05, docmann <docmann at gmail.com> wrote:
> 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
>