WampServer

Fresh install WampServer Version 3.0.6 64bit using Mysql 5.7.14

***Alter user root reset Windows 8.1- tutorial***

I was having trouble resetting the root pw for phpMyadmin.

I found out that any installation of after Mysql 5.7 needed a new command line to reset root.(Alter User syntaxt)

Some of the tutorials online were not helpful so I found my own way to reset root using a combination of different methods.

Here is what has worked for me

"How to reset root for phpMyadmin using mysql 5.7.14 console"

find component services in the administrative tools folder of your windows 8.1 control panel
find Mysql and stop it from running
....................
open mysql console (assuming your wamp server icon is green in the task bar)
..................................
if no password hit: enter or return
.......................
type: show databases
....................
type: UPDATE mysql.user SET authentication_string = PASSWORD('MyNewPass'), password_expired = 'N' WHERE User = 'root' AND Host = 'localhost';
......
*side note* where it says ('MyNewPass') create new password between single quotaions and perenthesis.
.....
hit: enter
......
Type: FLUSH PRIVILEGES;
...........
Type: Exit
.....
*Password should be updated for phpMyadmin login*
....
login to phpMyadmin using:
Username: root
login: MyNewPass (new pw you created using Alter User command line syntax)

***references***
"MySQL 5.7 Reference Manual / ... / How to Reset the Root Password"

[dev.mysql.com]

........

"Setting the MySQL Password in WAMP - Lucid Nerd Tutorial"

[youtu.be]

Hi,

After install of Wampserver 3.0.6 there is no password for Mysql.
So, you do not need to reset password.

And then, even if you later forgot the password you put, there is no need for video (*) to do it.
The textual procedure - therefore printable - has been posted on this same forum for more than ten months: [forum.wampserver.com]

(*) It is totally illusory to think that a video helps solve a PHP, Apache or MySQL problem. Nothing beats a good old paper written procedure that can be followed step by step, by checking the items made at progressively.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons



Edited 1 time(s). Last edit at 12/24/2016 10:16AM by Otomatic.