[REBOL] Re: MySQL scheme connection problem
From: dockimbel:free at: 23-Jul-2001 11:59
Hi Chris,
When the mysql client connect locally, it use Unix local sockets intead of TCP.
Use the 'status command under mysql and see the "Connection:" line. In that case,
your [name--host] doesn't seem to be resolve.
When you use my scheme, it always connect in TCP mode. So, the host is resolve
by Rebol (to 127.0.0.1, when you connect locally) and then a reverse-dns is applied
in the mysql server. If it doesn't find any matching entries in his 'user table, your
connection is rejected.
See what does the following command under your server's unix account :
>> read dns://127.0.0.1
I guess you'll obtain :
== wolverine.uk.co !
So, in order to use my scheme under your server, you have to grant access to either
[yourlogin--127--0--0--1] or [yourlogin--wolverine--uk--co] .
HTH,
DocKimbel.
Chris wrote: