Can't log in to database

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Cams
Registered User
Posts: 71
Joined: Fri Nov 07, 2003 7:18 pm
Location: Scotland
Contact:

Can't log in to database

Post by Cams » Fri Feb 16, 2018 7:23 am

I tried to update my forum from 3.19 to 3.2 yesterday and it broke. I managed to get the update to complete by changing 'mysql' to 'mysql' in config.php but here were still some issues, so I started copying files over from the full install package. Then, all of a sudden, I got this:
General Error
SQL ERROR [ mysqli ]

Access denied for user 'username'@'localhost' (using password: YES) [1045]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
I can still log into my cpanel and I know that the login credentials are correct in config.php, but I can't log into phpMyAdmin, and the error above (username changed - in the error, it's my own username) when I try to visit the forum.

Forum is at http://celticguitartalk.com/phpBB

User avatar
Mick
Support Team Member
Support Team Member
Posts: 19368
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff
Contact:

Re: Can't log in to database

Post by Mick » Fri Feb 16, 2018 9:32 am

The error is saying the credentials (password) for the database in config.php are incorrect. Knowledge Base - Rebuilding Your config.php File may help.
"The more connected we get the more alone we become" - Kyle Broflovski

There are no ‘threads’ in phpBB, they are topics.
Forza Garibaldi

Cams
Registered User
Posts: 71
Joined: Fri Nov 07, 2003 7:18 pm
Location: Scotland
Contact:

Re: Can't log in to database

Post by Cams » Fri Feb 16, 2018 9:48 am

They aren't though. I can sign in to the cpanel and change credentials for the database. I also set up a new user and password and changed config.php to the new credentials, but the problem persisted.

I'll take a look at the link you provided and see if it helps.

Thank you!

User avatar
canonknipser
Registered User
Posts: 1519
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: Can't log in to database

Post by canonknipser » Fri Feb 16, 2018 11:17 am

Keep in mind that user@localhost is a different user than user@% (% for "any host") for the mysql database. So re-check if you have set the credentials for the correct user (or create two users - one localhost and one % with the same credentials)
Greetings, Frank
phpbb.de support team member
English is not my native language - no support via PM or mail
New arrival - Extensions and scripts for phpBB

User avatar
Mick
Support Team Member
Support Team Member
Posts: 19368
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff
Contact:

Re: Can't log in to database

Post by Mick » Fri Feb 16, 2018 1:14 pm

Also, I see your board isn't setting cookies, you may have to speak to your host about that. If you don't get things sorted please fill out the Support Request Template and post it back here to enable us to assist you better.
"The more connected we get the more alone we become" - Kyle Broflovski

There are no ‘threads’ in phpBB, they are topics.
Forza Garibaldi

Cams
Registered User
Posts: 71
Joined: Fri Nov 07, 2003 7:18 pm
Location: Scotland
Contact:

Re: Can't log in to database

Post by Cams » Fri Feb 16, 2018 1:29 pm

I redid the database credentials in cpanel and it seems to have fixed it. I don't know anything about the cookies though. Is that a thing in cpanel too, or on the board's ACP?

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 49186
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Can't log in to database

Post by stevemaury » Fri Feb 16, 2018 2:19 pm

For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. PM or email me.

All unsolicited PMs will be ignored.

User avatar
Mick
Support Team Member
Support Team Member
Posts: 19368
Joined: Fri Aug 29, 2008 9:49 am
Location: Cardiff
Contact:

Re: Can't log in to database

Post by Mick » Fri Feb 16, 2018 6:44 pm

The cookie settings are good now BTW.
"The more connected we get the more alone we become" - Kyle Broflovski

There are no ‘threads’ in phpBB, they are topics.
Forza Garibaldi

Cams
Registered User
Posts: 71
Joined: Fri Nov 07, 2003 7:18 pm
Location: Scotland
Contact:

Re: Can't log in to database

Post by Cams » Fri Feb 16, 2018 6:47 pm

Great, all is well. Thank you all for the assistance.

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: david63, Lumpy Burgertushie, Sogou [Spider] and 71 guests