Rookie in the house

[Timelord_]

Hi guys, I am not here, just started with my first VPS, as I had outgrown my shared hosting elsewhere.

Support has been excellent thus far, but I am starting to feel a little guilty about creating tickets for all my issues, so I thought I would try this one here.

When I am attempting to access on of my domains, I get the following error.

Access denied for user 'root'@'localhost' (using password: NO)

However, I know I have defined a seperate user for the localhost DB. For the life of me I dont know where it is getting the "root" account from.

Anyhelp would be appreciated!

[Gwaihir]

So.. you told the database about that user, i.e. created it. Have you told your application as well? You probably need to fill out the DB-user and password in some configuration file of whatever application you're running on that domain.

[Timelord_]

Yeah, I did all that, so thats what makes it kinda weird that it isnt working..

[Gwaihir]

Hmm.. this is going to take more info. What exactly are you trying to do? Access a webpage? Access a database directly? What software is involved? I.e. what application runs behind that webpage, or how are you accessing that database?

[Timelord_]

I am in the process of installing a youtube type script.

I have created a DB for that domain, created a dbuser (although I am not 100% sure that the user I created has full control over that DB).

The error is generated when I try to access the url that the site is hosted on.

I hope this is enough information for you..

BTW, thanks for taking the time to help.

[Rob]

Timelord have you filled out the database info in the script?

Look for a config.php file or something along the same lines. There should be a readme file that came with the script - this should be able to tell you more info on how to install it.

[Ron]

Timelord, what script are you using?

Perhaps someone here is familiar with it.

[Timelord_]

I have tried with a couple of different scripts (clip-share, and agriya), but I think I may have a bigger issue here.

When I try to access any .php pages, I get a blank page.

Cheers!

[Timelord_]

Rob, I followed the readme.txt down to a TEE. I have installed these scripts 20-30 times, without issue, thats why I wonder if it is a config setting within the VPS>

Cheers!

[Gwaihir]

Does a phpinfo(); still work? In that case, php is working.

I suppose you could another type of database using script first, like phpMyAdmin, to rule out some more issues. But to be frank, I'd personally only bother with this step if I'd happen to need the extra application anyway.

Also, you're saying you're sailing the way you're used to. Did any of those previous times involve php in cgi mode? Although I can't match it with the specific error you're telling us, it might mean some minor changes in the way your script needs to be setup and configured.

[Ron]

Just going to toss out some suggestions...Look in your error log. Ensure the DB is up and running through the CLI and you can use the same username and password. Try running the php code via the CLI as well. try running a simple php script like

<?php 
echo "Hi"; 
?>

[thisisit3]

Are you sure you created your user properly? Because when you created your user you should have given him proper privileges for the specific database the user will be using: "GRANT ALL PRIVILEGES ...".

This is all done in cPanel's database administration.