How to reset the MySQL root userid with WAMPServer.
As this previous suggestion did not work using a WAMPServer installation and I have been meaning to work out a nice clean way to do this for some time now heres how its done using WAMPServer.
1. Stop the mysql service
wampmanager -> MySQL -> Service -> Stop Service
2. Edit the my.ini file
wampmanager -> MySQL -> my.ini
3. Find the [wampmysqld] section in the ini file
Add this line directly after the section [wampmysqld]
skip-grant-tables
4. Restart the mysql service.
wampmanager -> MySQL -> Service -> Start/Resume Service
5. Open a command window
At the command prompt change to the drive letter you installed wamp on ( D: in my case )
D:
CD into your mysql's executable folder (replace X,Y and Z with the versions number you are using )
CD \wamp\bin\mysql\mysqlX.Y.Z\bin
6. Now we are going to reset the password for the root user, of course this could be used to reset any users password.
Form the command prompt, run the mysql command line processor
mysql.exe
and enter the following 2 commands at the mysql> command prompt, each with a semi colon at the end of a line, and press ENTER after each line to issue the command to mysql.
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;
Note that the update should report that it has updated more than one row, that because there are actually 3 user accounts with the userid of 'root' each with a different domain i.e. 127.0.0.1, localhost and ::17. Now enter 'quit' at the mysql command promt to exist mysql.
8. Stop the mysql service
wampmanager -> MySQL -> Service -> Stop Service
9. Edit the my.ini file
wampmanager -> MySQL -> my.ini
10. Find the [wampmysqld] section in the ini file
Remove the 'skip-grant-tables' parameter we added earlier.
DO NOT Leave this parameter in the ini file its a HUGH security hole.11. Restart the mysql service.
wampmanager -> MySQL -> Service -> Start/Resume Service
You shoud now be able to login with phpmyadmin using the userid 'root' and the new password you have just set for that user.
---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>Read The Manuals Apache --
MySQL --
PHP --
phpMyAdminGet your Apache/MySQL/mariaDB/PHP ADDONs here from the
WAMPServer alternate Repo-X-X-X-
Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-