安装mysql时拒绝访问用户,MySQL-用户被拒绝访问

So, I create a new user

CREATE USER servname_shb IDENTIFIED BY 'password';

Grant him all the privileges:

GRANT ALL ON *.* TO servname_shb;

No errors so far. Then I try to connect to database:

$dbhost = "localhost";

$dbname = "servname_shbusers";

$dbuser = "servname_shb";

$dbpass = "password";

$c = mysql_connect($dbhost,$dbuser,$dbpass) or die("Error:".mysql_error());

mysql_select_db($dbname) or die ("Error connecting to databse:".mysql_error());

And get an error:

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

I tried FLUSH PRIVILEGES, dropping and recreating user - no effect. What am I doing wrong?

解决方案

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.