SQL ERROR [mysql4] Access denied for user

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Anti-Spam Guide
Post Reply
yadavvlsi
Registered User
Posts: 12
Joined: Sun Sep 28, 2014 5:34 am
Location: Bangalore, INDIA
Contact:

SQL ERROR [mysql4] Access denied for user

Post by yadavvlsi » Fri May 05, 2017 4:52 pm

I recently transferred my phpbb3 forum to a new server. I have transfer all required file and updated the database successfully. Now I have a new database and user name. I have updated the database and username in my config.php file as below

$dbname = 'XXXX_forum_db';
$dbuser = 'evlsixsb_admin';
$dbpasswd = 'XXXXXXXXXX';

But still I get below Error.

SQL ERROR [ mysql4 ]
access denied for user 'evlsicom_admin'@'localhost' (using password: YES) [1045]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.


evlsicom_admin was admin name on my old server. It is still looking with old username. New user name is "evlsixsb_admin" which I have updated in config.php. Here is my forum link.

http://www.evlsi.com/index.php

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

Re: SQL ERROR [mysql4] Access denied for user

Post by canonknipser » Fri May 05, 2017 6:26 pm

Did you clear the cache folder after changing config.php? In 3.1 it is cached.
Greetings
Frank
phpbb.de support team member
English is not my native language
New arrival - Extensions and scripts for phpBB
no support via PM or mail

yadavvlsi
Registered User
Posts: 12
Joined: Sun Sep 28, 2014 5:34 am
Location: Bangalore, INDIA
Contact:

Re: SQL ERROR [mysql4] Access denied for user

Post by yadavvlsi » Sat May 06, 2017 4:48 am

Thanks for your help. I have cleared phpbbinstall/cache folder. I have only index.htm and .htaccess file in cache folder. Now I am getting below Error

[phpBB Debug] PHP Warning: in file [ROOT]/vendor/composer/ClassLoader.php on line 412: include([ROOT]/vendor/symfony/dependency-injection/Compiler/MergeExtensionConfigurationPass.php): failed to open stream: No such file or directory
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/composer/ClassLoader.php on line 412: include([ROOT]/vendor/symfony/dependency-injection/Compiler/MergeExtensionConfigurationPass.php): failed to open stream: No such file or directory
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/composer/ClassLoader.php on line 412: include(): Failed opening '[ROOT]/vendor/symfony/dependency-injection/Compiler/MergeExtensionConfigurationPass.php' for inclusion (include_path='.:/opt/alt/php56/usr/share/pear:/opt/alt/php56/usr/share/php')


Looks like There is some directory structure issue. Where is ROOT directory set?

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

Re: SQL ERROR [mysql4] Access denied for user

Post by canonknipser » Sat May 06, 2017 7:21 am

reupload the vendor directory
Greetings
Frank
phpbb.de support team member
English is not my native language
New arrival - Extensions and scripts for phpBB
no support via PM or mail

yadavvlsi
Registered User
Posts: 12
Joined: Sun Sep 28, 2014 5:34 am
Location: Bangalore, INDIA
Contact:

Re: SQL ERROR [mysql4] Access denied for user

Post by yadavvlsi » Sat May 06, 2017 8:25 am

I have all the files present in the vendor directory. How re-uploading will solve the issue? File will remain the same. Correct ?

User avatar
david63
Jr. Extension Validator
Posts: 13127
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: SQL ERROR [mysql4] Access denied for user

Post by david63 » Sat May 06, 2017 8:41 am

yadavvlsi wrote:
Sat May 06, 2017 8:25 am
File will remain the same. Correct ?
Not necessarily. If one, or more, files has not uploaded correctly, or is corrupt, then re-uploading will overwrite that file.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

yadavvlsi
Registered User
Posts: 12
Joined: Sun Sep 28, 2014 5:34 am
Location: Bangalore, INDIA
Contact:

Re: SQL ERROR [mysql4] Access denied for user

Post by yadavvlsi » Sat May 06, 2017 10:00 am

There was some small issue with file name. Some how its extension got changed to .ph from .php
Now its working fine. Thanks for your help.

http://www.evlsi.com/index.php

Post Reply

Return to “[3.1.x] Support Forum”

Who is online

Users browsing this forum: No registered users and 18 guests

cron