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

[Nicero 0]

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?

[BobS 0]

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

[Nicero 0]

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

[janvankuijk 0]

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