11/3/2023 0 Comments Wamp reset phpmyadmin password![]() ![]() PS: reinstalling wamp will not harm your www data directory. You can also use Xmapp instead of wamp!I guess that can help to reset the mysql automatically. (Generally, this is the default location. Go to C:\xampp\phpMyAdmin or the place where it is installed. Step 1: Press Ctrl+R and type C:\xampp\phpMyAdmin (or) Navigate to that directory. If you have some strange error like Plugin 'FEDERATED' is disabled which you dont have any clue then reset the arch google with my.cnf and mysql reset Steps for finding the Username and Password of PhpMyAdmin: Here is the stepwise solution that will be followed as such to retrieve the credentials. If you can get access mysql for the first time when install wamp go to mysql console and when ask password simply press enter.This will enable the option for phpmysqladmin to log in straighaway. I no longer had permission to access phpmyadmin. I tried doing this for the root user, but ended up doing something wrong. If it denies to log in and says access denied using password.Use this link: There was always a warning at the bottom of the admin page about setting up a password. How to determine if a port is open on a Windows server? ![]() ![]() Now the password has been reset, we need to restart MySQL by logging out: quit and simply stopping and starting MySQL. check the port number 3306 and make it free.How to check if any port open or not use this Enter the new password for the root user as follows: update user set passwordPASSWORD('mynewpassword') where User'root' and finally, flush the privileges: flush privileges Restart. Click on the Wamp server icon > MySQL > MySQL Console Enter password: LEAVE BLANK AND HIT ENTER mysql> UPDATE er SET PasswordPASSWORD (‘MyNewPass’) WHERE User’root’ ENTER Query OK mysql>FLUSH PRIVILEGES ENTER mysql>quit ENTER mysql>bye Edit.In my case I tried to uninstall wamp couple of times and again install it but problem did not solve. However, the same password does not work on phpmyadmin GUI with new password. Re-configuring it from mysql console is successful. I was facing the same problem.Before that phpmysqladmin was working properly in wamp environment.I had took my time. I am not able to log in to phpmyadmin with root password using wampserver on windows 7. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |