Oops, used wrong email address
-----Original Message----- Sent: 08 August 2004 12:23 To: [EMAIL PROTECTED] Subject: creating a new user with "mysql" on 4.0.20a I am just going through some taching docs and it says that I can create a new user with all authority on a new DB using the command GRANT ALL ON llcopy.* TO auser IDENTIFIED BY 'thepassword'; yet when I try and run 'mysql' using mysql -uauser -pthepassword I get the error ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) Is there an easy way to GRANT priveleges to users no matter where they logion from? Kerry