XF 1.4 MySQL Password Error

[Captured Enigma]

I enter the password into the relevant field:
MySQL Password: $config['steamcha_forum']['*****'] (Stars being my pass but with different number of characters

It says:
The source database connection details are not correct: Access denied for user '$config['steamch'@'localhost' (using password: YES)

My password was right though

 

[Mike]

$config['steamcha_forum']['*****']

Are you saying that you edited config.php directly and, more specifically, replaced parts of the code (like
$config['db']['password']) rather than changing the value? (On the right side of the "=".)

 

[Captured Enigma]

Sorry, no. I enter the details for my db and it says this:
The source database connection details are not correct: Access denied for user 'steamcha-sg'@'localhost' (using password: YES)

The password is correct tho, my host checked.

im having a lot of trouble with this

 

[Mike]

All I can say is that the password isn't correct. That's MySQL telling you it's not correct; nothing XenForo is involved with.

 

[TheBoss]

Assuming you used CPanel to create your database in the first place did you remember to update its privilages to global, in other words did you check the select all box.?

 

[Captured Enigma]

I understand it it saying the pass is wrong, I created a user 'steamcha_admin' and assigned a password to that user which I enter here and it gives that error message

I did give him global privilidges yeah :/

 

[TheBoss]

From your first post:

It says:
The source database connection details are not correct: Access denied for user '$config['steamch'@'localhost' (using password: YES)

Looks like a simple spelling error , it appears you have missed adding the letter "a" after steamch .... In the rest of your posts it is steamcha@

 

[Captured Enigma]

From your first post:

It says:
The source database connection details are not correct: Access denied for user '$config['steamch'@'localhost' (using password: YES)

Looks like a simple spelling error , it appears you have missed adding the letter "a" after steamch .... In the rest of your posts it is steamcha@

Thanks for replying again mate, that one was a spelling error but it has been corrected in the previous posts.

Thanks for your help though, it really is appreciated I am gonna start the forum fresh

 

[TheBoss]

Just before you do... make sure if you are copying and pasting the text into username & database area's on entry..do NOT leave any spaces before or after the text..

The space is then assigned as %

 

[Captured Enigma]

I think that may have been the issue... Its fixed!

Thank you veery much

 

[TheBoss]

No probs, glad I could help you..

You might find this of some use in the future..
A guide I wrote for backing up your database the easy way.. Lets you manipulate tables direct , merge database tables...

https://xenforo.com/community/resources/database-backup-local-offsite.1554/

Regards