MySQL - Access Denied

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Scam Warning
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
User avatar
Khoala
Registered User
Posts: 14
Joined: Wed Feb 09, 2011 6:23 pm
Location: New York
Contact:

MySQL - Access Denied

Post by Khoala » Fri Mar 11, 2011 11:10 pm

Hello,

I messed up my MySQL root account, specifically I deleted it!! I already spent more than one day trying to figure out how to restore/fix it and I've been able to go into MySQL by skip-grant-tables and then I did create a root user with ALL privileges. It seems that everything is OK until I start the service again and realize that still have no access to my phpBB forum or any other function using MySQL database.

The error message is the following:

Code: Select all

SQL ERROR [ mysqli ]

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

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
I only get access to the forum by letting the server without checking privileges skip-grant-tables command.

I already checked Google like crazy.
I know this isn't a phpBB issue but I'm recurring to you because I have no more ideas on how to solve it and may is someone around here who got some MySQL knowledge.

I apologize if I shouldn't post this here.

Thanks in advance,

Khoala
Laptop: Samsung QX410-J01
Website: LetITgrow

Locked

Return to “[3.0.x] Support Forum”