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.
Scam Warning
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Locked
yadavvlsi
Registered User
Posts: 14
Joined: Sun Sep 28, 2014 5:34 am
Location: Bangalore, INDIA
Contact:

SQL ERROR [mysql4] Access denied for user

Post by yadavvlsi »

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: 2096
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 »

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 - no support via PM or mail
New arrival - Extensions and scripts for phpBB
yadavvlsi
Registered User
Posts: 14
Joined: Sun Sep 28, 2014 5:34 am
Location: Bangalore, INDIA
Contact:

Re: SQL ERROR [mysql4] Access denied for user

Post by yadavvlsi »

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: 2096
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 »

reupload the vendor directory
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
yadavvlsi
Registered User
Posts: 14
Joined: Sun Sep 28, 2014 5:34 am
Location: Bangalore, INDIA
Contact:

Re: SQL ERROR [mysql4] Access denied for user

Post by yadavvlsi »

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
Registered User
Posts: 20646
Joined: Thu Dec 19, 2002 8:08 am

Re: SQL ERROR [mysql4] Access denied for user

Post by david63 »

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!

I now no longer support any of my extensions but they will start to become available here
yadavvlsi
Registered User
Posts: 14
Joined: Sun Sep 28, 2014 5:34 am
Location: Bangalore, INDIA
Contact:

Re: SQL ERROR [mysql4] Access denied for user

Post by yadavvlsi »

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
Locked

Return to “[3.1.x] Support Forum”