install problem - won't accept password

[Walkinman]

hello,

I'm setting up Coppermine to run a series of slideshows on my backpacking website, and I'm having some trouble getting it set up. I had my webhost set up a mysql database, and they gave me all the passwords, and stuff like that. yet when I get to the 2nd page of the install.php program, I get this error:

Code Select Expand

Could not create a mySQL connection, please check the SQL values entered

MySQL error was : Access denied for user: 'carl@localhost' (Using password: YES)

The password isn't "yes", but it says this each time I type in the correct password. Also, it lists the MYSQL Table Prefix as cpg143_  .. what do I type in here? I'm just leaving it as is, is this giving me the above error?

Thank you

Cheers

Carl

[Nibbler]

The name probably isn't carl, it probably has your account name as a prefix.

[Walkinman]

Hey Nibbler,

Thanks - The info I got from my webhost said that the name, for both the username and the database, is Carl .. I can post, or send via pm, the Mysql information they sent me, but that's probably something I need to be careful with, correct?

What do you mean my 'account name'?

Thank you.

Cheers

Carl

[Sami]

1.

Code Select Expand

(Using password: YES)
it means Mysql use your password to connect , it dosn't mean that your password is "yes"
2. do not send your database password to public forum it's a major risk
3.if you use Cpanel az a control panel (Linux hosting) of your host your database name and also your username should have your domain name as a prefix.
for example if your domain is yourdomain.com your real database name is "youromain_XXXXX" (XXXX is the name that you choose for database) and your real username is "yourdomain_carl" your password remain "carl" but you should change it az soon az possible !!!!

[Walkinman]

Hello bmossavari,

Thanks for that, I understand a bit better now. I'm not using cpanel, but I believe it is Linux hosting.

I tried to install it using alaskanalpinetreks_carl as the database name and as the username, but I get the same error message:

Code Select Expand

Could not create a mySQL connection, please check the SQL values entered

MySQL error was : Access denied for user: 'www.alaskanalpinetreks.com_carl@localhost' (Using password: YES)

I tried it with www.alaskanalpinetreks.com_carl, alaskanalpinetreks.com_carl as well. It wouldn't work.

The password isn't 'carl'.

Any suggestions?

Thank you

Cheers

Carl

[Tranz]

Make sure the user is added to the database in terms of being given access rights. Creating a user doesn't automatically give it access to the databases.

[Walkinman]

hey TranzNDance

Thanks for your reply. I've forwared your words to my webhost, and will see if that is the problem. I really know nothing about it - they set up the database, but they're not very helpful. I'll see what they say and reply back when I hear.

Thank you.

Cheers

Carl

[Walkinman]

Hey Folks,

I got this message back from my webhost, but I don't knwo what it means, or what to do about it making it work now.

"What is going on is it appears that the program or command you are using to attempt to access mysql is not using the -p string to provide a password.
"

All help appreciated.

Thank you.

Cheers

Carl

[Walkinman]

Hello,

My web host has finally resolved the problem, and the installation is complete. I don't know what the issue was.

Thanks for your help. Moderators may now mark this thread as solved.

Cheers

Carl

[Tranz]

(I typed this before your post, but I'll post this for other's future benefit.)

From your past posts, you said you use Lunarpages. That's what I use, too. The db prefix is your cpanel username. So the mysql user would look like: cpanelusername_carl

Your database name would be the same:
cpanelusername_carl

since you said "both the username and the database, is Carl". But from the error message, it showed a lowercase carl....

[Walkinman]

Hey TranzNDance,

Thanks - unfortunately, I'm not using LunarPages with this website .. i wish I was, they're SO much better. This is an older website I've had for a number of years, and it's still on another server. I'll switch it to Lunarpages also when my current billing cycle ends.

And yes, the username and database is 'carl', with a lowercase . that was a typo on my part here on the forum. Sorry about that.

My Webhost had done something wrong when they set up the database, but I don't know what.

Thanks again.

Cheers

Carl