Jump to content


Photo

Coral 8.5.2: #1045 - Access denied for user 'root'@'localhost' (using password: YES)


  • Please log in to reply
3 replies to this topic

#1 Nicero

Nicero

    Newbie

  • Member
  • Pip
  • 6 posts
  • Main OS: Windows 7

Posted 08 May 2012 - 05:10 AM

I'm using Coral 8.5.2.
I accidentally deleted the 'root' MySQL account from PHPmyAdmin and now I get the error:

#1045 - Access denied for user 'root'@'localhost' (using password: YES)

I tried every solution I read about but I still can't access PHPmyAdmin. This I what I've tried so far:

1. Restore MySQL password via Coral interface: Server configuration -> MySQL -> Restore password
2. Change MySQL password to 'root' via Coral interface: Server configuration -> MySQL -> Change password
3. Edit PHPMyAdim config.inc.php which now is as follows:
$cfg['Servers'][$i]['auth_type']  = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = $password;
$cfg['Servers'][$i]['AllowNoPassword'] = false;

But I also tried the following combinations:
$cfg['Servers'][$i]['auth_type']  = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';
$cfg['Servers'][$i]['AllowNoPassword'] = true;

Nothing worked. I'm using Windows XP and I'm working locally.

Any help, please?

#2 BobS

BobS

    Project Helper

  • Super Moderator
  • PipPipPip
  • 334 posts
  • Location:Santiago Chile
  • Interests:Retiring, computer systems, system design, model railroads....
  • Wiki ID: BobS
  • Main OS: Windows 7

Posted 08 May 2012 - 08:23 AM

BANG!! Oops, hit my foot.
Well, this is rather difficult to resolve, since it's like locking your keys in the car.

Recall that phpMyAdmin doesn't really have any separate accounts. It uses the accounts of MySQL. Here's one way to get you back in operation, but you'll lose any restricted users you created.

First, be sure MySQL is stopped.
Go to usr\local\mysql\data\mysql and copy the user.* files to another directory for safety.
Then create a separate extraction of Coral_8.1.2. Go to usr\local\mysql\data\mysql and copy the user.* files to your active server. This effectively resets the user list by brute force.
Restart MySQL. Note that the root password is reset to the default, 'root'.

This isn't a clean method, but it will get you running so that you can backup everything and reinstall.

Regards,
BobS

#3 Nicero

Nicero

    Newbie

  • Member
  • Pip
  • 6 posts
  • Main OS: Windows 7

Posted 08 May 2012 - 09:17 AM

Hi Bob!

Yes you're right, it's exactly what happened: I locked my keys inside the car!

I did as you suggested and it worked perfectly.

Thank you.
Regards,
Enrico

#4 janvankuijk

janvankuijk

    Newbie

  • Member
  • Pip
  • 1 posts
  • Main OS: Windows Vista

Posted 12 September 2013 - 06:05 AM

Hi,

 

I've tried this, but without any result. Keeps the error.

 

When I start as a program, you can change the password.

This gives this error:

 

 

 

Regel: 173

Teken: 13

Fout: %1 is geen geldige Win32-toepassing.

Code: 0

url: file : /// C: /Webserver/ UniServer/ uni_con/ uni_con_program. hta

 

 

 

 

Jan






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users