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
