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