When issueing the following:
mysql> GRANT ALL ON storage.* to 'dwhitson'@'IP Address' IDENTIFIED BY 'password';
ERROR 1044 (42000): Access denied for user 'admin'@'localhost' to database 'storage'
Anyone seen this or have any ideas what the issue might be please let me know; thanks.
Try doing the following before you run that query...
1. log into the database as the admin user.
2. use mysql database.
3. execute the following: update user set Grant_priv='Y' where user='admin';
4. execute the following: flush privileges;
5. exit mysql.
6. repeat steps 1 and 2 above.
7. execute your query.
These steps worked for me.