Phptheadmin access denied due to accidentally lock account

MySQLphpmyadminxampp

Hello my Xampp was working and I access also the phpmyadmin in website, at first I was able to access the PhpMyAdmin site when I was there I accidentally lock the local host after that I was not be able to access it again I tried so many ways to fix that but unfortunately I did not fix it I don't know you could help me with that but i'm trying, I think I click "user" in phpmyadmin site and I saw the "root" which is the local host and I accidentally click the lock account, after that I didn't access it again please help me that is my first time using phpmyadmin, i've watched a lot of tutorials but i didn't found exactly the tutorials that I was looking for, I don't know how to fix it, please help.

Best Answer

I had the same problem, in XAMPP open Apache - config then in phpMyAdmin(config.inc.php) change $cfg['Servers'][$i]['user'] = 'root'; instead of "root" put another user "pma" work for me, then unlock the account, then put the config.inc.php with the user "root" again. that works for me.

Related Solutions

Word – #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)

You will probably need to edit config.inc.php as superuser and not as your regular user account. You can accomplish this with

sudo nano /path/to/config.inc.php

(sudo causes the command that follows it to run as an administrator, essentially; nano is a command-line text editor)

It will prompt you for your mac user's password, and then launch the editor with administrative privileges (which can edit the file). Make your changes to it, and then press Ctrl+O to save the changes, and then press Ctrl+X to exit and return to the command prompt. You should then be able to log in to phpmyadmin.

The changes you'll probably need to make are:

$cfg['Servers'][$i]['password'] = 'thenewpasswordthatyouchangedto'

If you would like to revert the changes you made (go back to not using a password), you may try the following from the command line:

mysqladmin -u root -p password ''

It will prompt you for the password you set on root, enter it, and then it should go back to root not having a password.

Xampp fatal error

May be your old installed xampp is not uninstalled properly. Follow this steps :-

1) Delete 'xampp' folder in 'C:/',

2) Delete 'MySQL' folder in 'C:/Program Files' if there,

3) Delete 'Apache Software Foundation' folder in 'C:/Program Files' if there.

4) Restart your PC/Laptop,

5) Install xampp again.

If you want to prevent your folder data then copy them into a temporary folder. After installation cut them and copy to their relevant locations.

Best Answer

Related Solutions

Word – #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)

Xampp fatal error

Related Question