mysql_connect（）访问被拒绝

Question

I'm having a problem with this connection. I've also done "grant all" for this user

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'kristian'@'localhost' (using password: YES) in connection.php on line 8
Failed to connect to MySQL: Access denied for user 'kristian'@'localhost' (using password: YES)

the connection.php

<?php

define('DB_HOST', 'localhost');
define('DB_NAME', 'email');
define('DB_USER', 'kristian');
define('DB_PASSWORD', 'password');

$con=mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("Failed to connect to MySQL: " . mysql_error());
$db=mysql_select_db(DB_NAME,$con) or die("Failed to connect to MySQL: " . mysql_error());

?>

Answer 1

First of all, use mysqli instead of mysql. Also try running

GRANT ALL PRIVILEGES ON email.* TO kristian@localhost IDENTIFIED BY 'password';

to make sure you have the correct access rights.