mysql仅php,mysql“拒绝用户访问” （仅在通过php连接时发生）

I created user dashboard and granted it various privileges (such as SHOW DATABASES). I initially set the Host=[private ip of web-server], but kept getting access denied errors returned from php's mysql_connect, so I set Host=192.168.% so any machine on our network can access it.

I can successfully connect to the mysql Db on the Db server from my Mac using MySQLWorkbench (and successfully ran SHOW DATABASES;), but when I just try to connect via php on our webserver, I just get: Access denied for user 'dashboard'@'192.168.xx.xx' (using password: YES)

the code i'm using in php is:

$dbhost = "192.168.x.x"; // but no x's

$dbuser = "dashboard";

$dbpass = "password"; // i copied&pasted the real password for other successful logins

$dbconnect = mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());

$query = mysql_query('SHOW DATABASES;');

?>

echo $query ?>