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.