bit of mysql help?
[1/5] from: notofo:earthlink at: 6-Jan-2004 16:21
hi guys,
I can open up the mysql listener from bash, and access a database, but
when I try to use the mysql.r protocol,
a: open mysql://user:[pass--localhost]/database
I get, "cannot connect to localhost"
what can I look at to fix this?
--
signature riding a horse: "clopclopclopclop"
-tom<
[2/5] from: petr:krenzelok:trz:cz at: 6-Jan-2004 23:29
Tom Foster wrote:
>hi guys,
>
>I can open up the mysql listener from bash, and access a database, but
>when I try to use the mysql.r protocol,
>
>a: open mysql://user:[pass--localhost]/database
>
try 127.0.0.1 instead of localhost?
-pekr-
[3/5] from: dockimbel:free at: 7-Jan-2004 0:18
Hi Tom,
I guess you're on a unix system. If you connect locally, the C mysql client use
local sockets while mysql.r use TCP ports. So the points to check are :
- Does your mysql server run on the default port 3306 or different one ?
- Does your mysql server allow for TCP connection ?
- Is your [user--localhost] authorized to connect to "database" ?
On Linux, a reverse DNS under REBOL often give localhost.localdomain instead of
just localhost. If it's the case, the simplier way to workaround that is to
grant access to [user--localhost--localdomain] on mysql server.
HTH,
-DocKimbel
Tom Foster wrote:
[4/5] from: carlos:lorenz:bol at: 7-Jan-2004 9:00
Em Ter 06 Jan 2004 19:21, you wrote:
did you try a: open mysql://user:[pass--127--0--0--1]/database instead?
carlos
[5/5] from: notofo:earthlink at: 7-Jan-2004 17:02
On Wed, Jan 07, 2004 at 09:00:55AM -0200, Carlos Lorenz wrote:
> Em Ter 06 Jan 2004 19:21, you wrote:
>
> did you try a: open mysql://user:[pass--127--0--0--1]/database instead?
>
Thanks guys, I fixed it. It was two things: networking was disabled
with mysqly and I had to grant my user privilages for the actual
machine name, not just "localhost."
Anyway, I can connect. now then...
--
signature sneezing: "achoo!"
-tom<