HELP!!! Please it's urgent. connection problems

Access denied for user: 'httpd@localhost' (Using password: NO)

This is the error I am getting!!!

I have leafed through other posts, but can not seem to find the exact answer I am looking for.

My database and mysql server is on my web sites host, I created a user that had all access rights, though I can't seem to create a simple admin user because it says they are already created. However it doesn't show them in my server's database information.


I know it is partway connecting, because if i change the host it gives me the error i put in with the php coding.

This is my code:
[highlight=php]
//url of sys
$system_url="http://thetippedcanoe.com";
//db parameters
$host = “64.21.163.2”;
$user = "root";
$password = "";
$database = “thetippedcanoe”;

//session timeout
$profile_timeout = 480;

$connection = mysql_connect ($host,$user,$password) or die("You can not connect" . mysql_error());
[highlight=php]

Your password is set to null. You need to specify the password. Contact your host if you don't know it and cannot find it yourself, they should be able to tell you how to get it or what it is.

I would assume that if they did their job you cannot connect as a root user from a remote host for security reasons. So you may try and either use a username that is not a root user but has the permissions you desire, or set up a new user with the appropriate permissions and use that.

Yes I did contact them, they are slow in responding.

I also have already set up a user and password with dba granted access rights.

Unfortunately even when I try using those in my config file they don't work either and i get the same message.
I'm not sure why it says httpd instead of my username in the error message though. I think that may have something to do with it.

ugh.

on which server are your php files located?

If they are on the same machine as the database, try using $host = "localhost" - but you have to use a password, unless you set up a user that does not need one (not recommended). Try the user you created.

Who is your web host?

Tried that, localhost does not work either.



my hosting service is pwebtech.com

Feel free to contact me email or messanger to help. yup yup

myraleen@hotmail.com

ok so they got back to me and i am STILL stuck.

This is what they say:
For some reason, whatever user runs the 'theTippedCanoe.php' file, is what that file takes as the user to pass onto the config.inc script to login to mysql. I know this because when I tried running the .php script from the command line as root it gave the same error, but it said user 'root@localhost' instead of http.

Maybe you will be able to look at your code, and see why it is doing this. I hope this helps.

Oh, and the I tried connecting to the database as akasha, and it works fine, just to let you know.

The only other thing I can suggest for now, is to try connecting to the database without using variables in the script, just force the actual info, and see if it connects. Hope it works.

Do you know what that might mean???

Why don't you try this code, and see what happens:If nothing then IM me.

Peter