Skip navigation links

MySQL Forums :: Install :: Reset MySQL root password


Advanced Search

Re: Reset MySQL root password
Posted by: Barry Galbraith ()
Date: May 25, 2012 07:39PM

>1) UPDATE mysql.user SET Password=PASSWORD('newpd') WHERE User='root';
FLUSH PRIVILEGES;


Eh!?
How did you do that if you can't login?

>C:\mysql\bin>mysql -u -passord -p

You've made a mess with the commandline arguments.

Try
C:\mysql\bin>mysql -uroot -p

Good luck,
Barry.

Options: Reply•Quote


Subject Written By Posted
Reset MySQL root password jeff shu 04/01/2012 03:58PM
Re: Reset MySQL root password Barry Galbraith 04/01/2012 05:19PM
Re: Reset MySQL root password jeff shu 04/01/2012 09:46PM
Re: Reset MySQL root password Barry Galbraith 04/01/2012 09:59PM
Re: Reset MySQL root password jeff shu 05/25/2012 01:14PM
Re: Reset MySQL root password Barry Galbraith 05/25/2012 07:39PM
Re: Reset MySQL root password jeff shu 05/27/2012 05:01AM
Re: Reset MySQL root password John Foy 05/31/2012 11:56AM


Sorry, you can't reply to this topic. It has been closed.
powered by phorum

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.