Adding Additional Users to Existing Database

[Laurel Bowen]

I am trying to add a new user/password to an existing database, cranber_store with an original user name of cranber_db

I typed at the command line (using my root access):
root@vps [/]# mysql -u cranber_db -password
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 23173 to server version: 4.0.23-standard


mysql> GRANT ALL PRIVILEGES ON *.* TO 'cranberryhollow'@'localhost'
-> IDENTIFIED BY 'chstore01' WITH GRANT OPTION;
ERROR 1045: Access denied for user: 'cranber_db@localhost' (Using password: YES)

When I tried to Grant all privileges to cranber_db, I get the same error (thinking I might have set up the original user name without all privileges).