how to change mysql password in WampServer Version 3.0.6 32bit

Question

I recently installed WampServer Version 3.0.6 32bit, i am trying to change the password of mysql. it shows the first error "No database selected". i selected the "MySql" database and try to create a password then it shows "Unknown column 'password' in 'field list'"

The command m using is "update user set password=password('abc@jkl') where user='root';

This can be helpful: http://stackoverflow.com/questions/22774739/change-mysql-user-password-using-command-line — wanna know, Mar 08 '17 at 17:58

score 4 · Accepted Answer · edited May 27 '18 at 16:51

Open the MySQL console by selecting the menu shown above.
After clicking on the “MySQL console” following console window will be opened where default password is empty so we hit one enter key to continue without typing.

3.Now in order to change the default password we need to type following query in the MySQL console (in this example we are setting the password to– “foo“)

`SET PASSWORD FOR root@localhost=PASSWORD('foo');`

4. In the older versions of the phpmyadmin we need to manually change the password in the phpmyadmin config file but in the current version we can skip this step.

how to change mysql password in WampServer Version 3.0.6 32bit

1 Answers1