3 messages in com.mysql.lists.mysqlRe: connection error
FromSent OnAttachments
Robert Morgan13 Sep 2003 01:08 
Fred van Engen13 Sep 2003 04:02 
Paul DuBois13 Sep 2003 09:58 
Subject:Re: connection error
From:Fred van Engen (fred@xbn.nl)
Date:09/13/2003 04:02:40 AM
List:com.mysql.lists.mysql

Robert,

On Sat, Sep 13, 2003 at 08:08:48PM +1200, Robert Morgan wrote:

I have created a user grant all privileges on *.* to user@"%" =>identified by ' pword' with grant option;

and grant all privileges on *.* to user@localhost =>identified by ' pword' with grant option;

Did you actually use a space in ' pword' ? You could try changing it to a password without a space in it.

but when I try and connect through mysql client(DBTools) on remote PC I get the
'access denied for user: user%@192.168.0.2' (using password:yes).

This suggest you tried to log on with a username 'user%' instead of 'user'.

Regards,

Fred.