The only way to get MySQL on Mandrake or Red Hat with JDBC to work is to use
a
GRANT ALL PRIVILEGES on <database>.* to <username>@"%" identified by
'<password>'
With the appropriate substitutions, if you don't use the hostname wildcard
("%") the Linux distros expand the localhost to the full
localhost.localdomain which is rejected in th elogin. If you use the
combined <username>@<hostname> it is too long for MySQL to accept.
-----Original Message-----
From: David Wynter [mailto:david@;roamware.com]
Sent: 06 November 2002 19:12
To: Turbine Users List
Subject: RE: Turbine failing to access MySQL database - help?
Hi,
I have more information now. There is a bug in Red Hat and Mandrake distro
where it uses localhost.localdomain instead of localhost for the host name.
So even though you use loacalhost as the host in your url string it uses the
longer version. This seems simple enough until you try to GRANT
PRIVILEGES... for localhost.localdomain and it won't let you because an
error occurs saying the host name is too long!.
I will keep plugging away at it.
David
-----Original Message-----
From: Chris K Chew [mailto:chris@;fenetics.com]
Sent: 06 November 2002 18:28
To: Turbine Users List
Subject: RE: Turbine failing to access MySQL database - help?
Do the log files say anything? The mysql documentation describes how to
configure logging, I don't remember it logging by default.
Chris
--
To unsubscribe, e-mail:
<mailto:turbine-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail:
<mailto:turbine-user-help@;jakarta.apache.org>
--
To unsubscribe, e-mail:
<mailto:turbine-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail:
<mailto:turbine-user-help@;jakarta.apache.org>
--
To unsubscribe, e-mail: <mailto:turbine-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:turbine-user-help@;jakarta.apache.org>
