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 [EMAIL PROTECTED] > =>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: [EMAIL PROTECTED]' (using password:yes). > This suggest you tried to log on with a username 'user%' instead of 'user'. Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
