GRANT ALL PRIVILEGES ON *.* TO  'username'@'localhost'  IDENTIFIED  BY  'somepassword';

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

GRANT ALL PRIVILEGES ON dbname.* TO  'username'@'localhost'  IDENTIFIED  BY  'somepassword';

SHOW GRANTS FOR username;

Access denied for user 'root'@'localhost' (using password: YES)