An excerpt taken from oneandone- "The MySQL database is stored on a separate database server behind a firewall to protect your data. You can only access this database server and your database exclusively through your site. Direct access to the MySQL database using a home PC (external ODBC connection) cannot be established."
I'm moving Host. Can you suggest anyone? Regards Martin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of docmann Sent: 28 April 2005 11:16 To: [EMAIL PROTECTED] Cc: How to use Revolution Subject: Re: MySQL Database Query Builder Question 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 <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > >> [mailto:[EMAIL PROTECTED] On Behalf Of > > >> [EMAIL PROTECTED] >> 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: [EMAIL PROTECTED] > > >> >[mailto:[EMAIL PROTECTED] 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 [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
