[REBOL] Re: MySQL scheme connection problem
From: chris::starforge::co::uk at: 22-Jul-2001 9:35
On 22-Jul-01, MCCUNI wrote:
> Or you can give your user a wildcard "*" access "from" and you can access
> from anywhere.
Thanks to help from my hoster I got this fixed. Now for the weirdness:
I have MySQL, Apache and other tools set up on my linux box so that it is
practically a mirror of my website. 99% of the time, if it works on my home
system I can upload it to the website and be sure it'll work. This is the
case with my sql scripts - at home I could do
db: open mysql://starforg_chris:[xxxxx--localhost]/starforg_siteserv
and it worked fine.
But when I uploaded the script to my website it failed? After a bit of
investigation, I found a possible reason. When I used @localhost on my
website mySQL was seeing "wolverine.uk.co" rather than "localhost". All I
can think is that the mySQL scheme is resolving localhost as part of the
open (I have no idea if this is true, half the code in the scheme is Greek
to me..) So instead of logging in as starforge_chris:[xxx--localhost] I was
actually logging in as starforg_chris:[xxxx--wolverine--uk--co] My hoster added
an entry to mysql.user to allow me to connect from wolverine.uk.co and
everything works fine now.
What I can't understand is why localhost is being resolved or why mySQL
can't work out that wolverine.uk.co IS localhost.
But it works now anyway :)
Chris
--
New sig in the works
Explorer2260, Designer and Coder
http://www.starforge.co.uk
--
Somebody ought to cross ball point pens with coat hangers so that the
pens will multiply instead of disappear.