Wamp reset phpmyadmin password update#

UPDATE er SET Select_priv='Y', Insert_priv='Y', Update_priv='Y', Delete_priv='Y', Create_priv='Y', Drop_priv='Y', Reload_priv='Y', Shutdown_priv='Y', Process_priv='Y', File_priv='Y', Grant_priv='Y', References_priv='Y', Index_priv='Y', Alter_priv='Y', Show_db_priv='Y', Super_priv='Y', Create_tmp_table_priv='Y', Lock_tables_priv='Y', Execute_priv='Y', Repl_slave_priv='Y', Repl_client_priv='Y', Create_view_priv='Y', Show_view_priv='Y', Create_routine_priv='Y', Alter_routine_priv='Y', Create_user_priv='Y', Event_priv='Y', Trigger_priv='Y', Create_tablespace_priv='Y' WHERE User='root' (Given the length of the first line, it is necessary to perform copy / paste). Reassign all privileges to root : 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 er SET authentication_string = PASSWORD('MyNewPass'), password_expired = 'N' WHERE User = 'root' Ħb. UPDATE er SET Password=PASSWORD('MyNewPass') WHERE user='root' Now we are going to reset the password for the root user, of course this could be used to reset any users password.Įnter 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. Wampmanager -> MySQL -> Service -> Start/Resume ServiceĦa. Find the or section in the ini fileĪdd this line directly after the section or Wampmanager -> MySQL -> Service -> Stop Serviceģ. The Windows session must be administrator and Wampserver started as administrator. If you have set a password for the root user, but you have forgotten it, or you accidentally deleted all with root privileges, you can choose a new password and re-allocate privileges the following procedure in Windows: Yhis is because for MySQL version since 5.7.0 the column name is changed.

ERROR 1504 (42S22) : Unknown column 'password' in the 'field list'.

Wamp reset phpmyadmin password