Go Back   Tech Support Forum > Design Forum > Web Serving and Management

User Tag List

MySQL Access denied error

This is a discussion on MySQL Access denied error within the Web Serving and Management forums, part of the Tech Support Forum category. Running a phpbb3 forum on mySQL 5.5 . I am presently getting the following error: ***START*** SQL ERROR [ mysqli


Closed Thread
 
Thread Tools Search this Thread
Old 08-12-2015, 10:43 PM   #1
Registered Member
 
Join Date: Aug 2015
Posts: 1
OS: Win10



Running a phpbb3 forum on mySQL 5.5 . I am presently getting the following error:

***START***

SQL ERROR [ mysqli ]
Access denied for user 'ambell_user2'@'localhost' (using password: YES) [1045]

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 757
CALL: trigger_error()

FILE: [ROOT]/includes/db/mysqli.php
LINE: 104
CALL: dbal->sql_error()

FILE: [ROOT]/common.php
LINE: 140
CALL: dbal_mysqli->sql_connect()

FILE: [ROOT]/index.php
LINE: 20
CALL: include('[ROOT]/common.php')

***END***

Here's what I did to cause it:

1. I reset the password for user ambell_user1 in cPanel and updated phpbb's config.php with the new info.

2. Checked and forum functioned correctly.

3. I deleted a couple of unused users and a couple of unused databases from the same account in cPanel

4. I then noticed the SQL ERROR.

5. At the time of the error, ambell_user1 was the only user assigned to the database. ambell_user2 was not.

6. I updated config.php with user ambell_user2 and password. The error remains.

7. I tried creating a new user and assigning it to the database, but the error remains.

Regardless of what user (new or existing) I enter into the phpbb config file, the error always shows ambell_user2 denied.

I do not know mysql, but I have read that there may be a statement (flush-privileges or reload) that will reset user privileges and hopefully clear up the problem, but I was unable to figure out the syntax.

Any assistance is appreciated!
mygotooffice is offline  
Sponsored Links
Advertisement
 
Old 08-13-2015, 07:40 PM   #2
Manager
- Alternative Computing
- Design
 
wmorri's Avatar
 
Join Date: May 2008
Location: New York
Posts: 6,492
OS: Window 7/Ubuntu/Fedora/Backtrack 5

My System

Send a message via AIM to wmorri Send a message via MSN to wmorri

Hi,

I would start with restaring mysql. Sometimes that is just the fix that you need. If that doesn't work, because you have a hosting plan I would talk to your hosting company. They usually deal with these problems frequently and should have a good idea how to fix it quickly.
__________________


Linux Forever!|html5 boilerplate
wmorri is offline  
Old 09-12-2015, 02:42 AM   #3
Registered Member
 
Join Date: Sep 2015
Location: Derbyshire
Posts: 1
OS: win8



Have you tried any debuging to see what values are present as you move though the php code. Try an echo statement for the username and password at various points in the code to ensure they are present as you would expcect

eg

echo "user here is ". $user:
echo "password here is ". $pwd;
belperifs is offline  
Sponsored Links
Advertisement
 
Old 01-07-2016, 05:12 PM   #4
TSF Enthusiast
 
BrentC's Avatar
 
Join Date: May 2007
Posts: 1,116
OS: Vista Home Premium



Did you create a username with a password using mySQL databases, if your hosting service provides this?
BrentC is offline  
Old 01-10-2016, 08:55 PM   #5
Manager
- Alternative Computing
- Design
 
wmorri's Avatar
 
Join Date: May 2008
Location: New York
Posts: 6,492
OS: Window 7/Ubuntu/Fedora/Backtrack 5

My System

Send a message via AIM to wmorri Send a message via MSN to wmorri

I am closing this as it is over 3 months old with no reply.
__________________


Linux Forever!|html5 boilerplate
wmorri is offline  
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads
Thread Thread Starter Forum Replies Last Post
Internet Explorer stops responding or runs slow
I have an older laptop with an Intel processor and 4GB of RAM running Vista. I am having issues which seem mainly to be in Internet Explorer and to a lesser extent in other programs as well. There are times when going into Windwos Mail that I get a message at the top of the page that says not...
jackdup Resolved HJT Threads 61 01-03-2015 03:15 PM
Suspect audio virus and tool bar removal
Good evening and thank you for your efforts so far. I use an Acer AX1200-B1581A running Win 7 64 bit. Every audio source that I play is interrupted with silence or tone intervention. This includes internet sources as well as CD drive. I am older, my glasses are in the shop and I sincerely hope I...
sonofwilliam Resolved HJT Threads 81 03-19-2013 08:30 AM
Help Please
Dear Sirs My computer crashed on Sunday night 18.03.2012. I can now only open it in safe mode. On Sunday night I was removing what I thought to be dangerous files, using my Antivirus Program Microsoft Security Essentials when the computer crashed. There were 4 Files that I was attempting...
Jack Willday Resolved HJT Threads 83 05-01-2012 02:51 PM
Trouble with Directx 10
When trying to install a redist for a game i was going to play, this error comes up: "An internal system error occured. Please refer to DXERROR.log and Directx.log in your Windows folder to determine the problem" This is my DXError.log: -------------------- module: dxupdate(Sep 4 2009),...
xAtlas PC Gaming Support 1 07-29-2011 01:43 PM

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is on
Smilies are on
[IMG] code is on
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Post a Question


» Site Navigation
 > FAQ
  > 10.0.0.2
Powered by vBadvanced CMPS v3.2.3


All times are GMT -7. The time now is 07:53 PM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.1.0 (Pro) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
Copyright 2001 - 2018, Tech Support Forum

Windows 10 - Windows 7 - Windows XP - Windows Vista - Trojan Removal - Spyware Removal - Virus Removal - Networking - Security - Top Web Hosts