Jump to content
The Uniform Server Community
Sign in to follow this  
Nicero

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

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...