MySQL - Access denied for user [duplicate]

The error messages gives you a hint already. Use this grant statement:

GRANT ALL ON *.* TO 'servname_shb'@'localhost';

Or better, as @grantk points out in the comments, refine the access scope to only what is actually needed.

You must use 'servname_shb'@'localhost' as the username. Your request become:

CREATE USER 'servname_shb'@'localhost' IDENTIFIED BY 'password';
GRANT ALL ON *.* TO 'servname_shb'@'localhost';

Note: 'servname_shb'@'localhost' only allow connection from localhost. You can use 'servname_shb'@'%' to allow connection from everywhere.

Related