2 messages in com.mysql.lists.javaRe: correction/followup to: can't con...
FromSent OnAttachments
Dov Kruger21 May 2004 10:25 
Hassan Schroeder21 May 2004 15:09 
Subject:Re: correction/followup to: can't connect
From:Hassan Schroeder (has@webtuitive.com)
Date:05/21/2004 03:09:18 PM
List:com.mysql.lists.java

Dov Kruger wrote:

In the troubleshooting section, the manual states that the problem is permissions, and that:

GRANT ALL PRIVILEGES ON [dbname].* to '[user]'@'[hostname]' identified by '[password]';

will solve the problem. A note also indicates that "Redhat linux is broken..."

and that the hostname should be "localhost.localdomain"

Thus, the following command:

GRANT ALL PRIVILEGES ON nyhos.* TO 'mysql@localhost.localdomain' identified by
'passwd';

would seem to be the command,

Nope, watch those tick marks -- per the manual,

GRANT ALL PRIVILEGES ON nyhos.* TO 'mysql`@`localhost.localdomain' ...

would seem to be the command :-)

HTH!

dream. code.