Problem connecting to my SQL, HELP

[jekwumoore]

I have created a database

database name is africadi_students

username: africadi_openme

password: africadi_meandme


My problem is trying to connect to my sql database via php

I have already created a php file named datatest.php

I inserted this code below to test it

<?php
mysql_connect("localhost", "africadi_openme", "africadi_meandme") or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_select_db("africadi_students") or die(mysql_error());
echo "Connected to Database";
?>

but when I try running the script via datatest.php I get the following error message displayed below

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'africadi_openme'@'localhost' (using password: YES) in /home/africadi/public_html/datatest.php on line 2
Access denied for user 'africadi_openme'@'localhost' (using password: YES)

please try and solve the problem when you have time, thanks


I have been having this problem for over a month now, what is wrong?

 

[v2Media]

User africadi_openme doesn't have permission to access africadi_students from host localhost.

MySQL user permissions table need an entry for africadi_openme to access africadi_students via localhost. You'll also have to give africadi_openme select, insert and delete permissions on africadi_students.

http://dev.mysql.com/doc/refman/5.1/en/adding-users.html

 

[jekwumoore]

Thanks, I already fixed that, it should have been meandme for the password instead of africadi_meandme I added the root of my website to the password, thats what went wrong.