Nicero Posted May 8, 2012 Report Share Posted May 8, 2012 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 password2. Change MySQL password to 'root' via Coral interface: Server configuration -> MySQL -> Change password3. 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? Quote Link to comment Share on other sites More sharing options...
BobS Posted May 8, 2012 Report Share Posted May 8, 2012 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 Quote Link to comment Share on other sites More sharing options...
Nicero Posted May 8, 2012 Author Report Share Posted May 8, 2012 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 Quote Link to comment Share on other sites More sharing options...
janvankuijk Posted September 12, 2013 Report Share Posted September 12, 2013 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: 173Teken: 13Fout: %1 is geen geldige Win32-toepassing.Code: 0url: file : /// C: /Webserver/ UniServer/ uni_con/ uni_con_program. hta Jan Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.