<div>
mysql&gt; update user set password=PASSWORD(&quot;NEWPASS<wbr />WORD&quot;) where User='USERNAME';<br />
<br />
I want to change my password to <br />
'pass'
</div>


<div>
<div class="content wysiwyg-content">
windows mysql<br />
<br />
I have no phpadmin access<br />
<br />
I have access to mysql commandline and mysql workbench query editor<br />
<br />
<br />
I want to change (add) the password<br />
<br />
there is currently no password<br />
<br />
but last time I tried<br />
<a href="https://www.experts-exchange.com/questions/28031150/I-think-I-deleted-my-databases-in-wamp.html" rel="ugc">https://www.experts-exchange.com/questions/28031150/I-think-I-deleted-my-databases-in-wamp.html</a><br />
I got error<br />
<br />
I locked root out and couldnt see my databases
</div>
</div>


windows mysql

I have no phpadmin access

I have access to mysql commandline and mysql workbench query editor


I want to change (add) the password

there is currently no password

but last time I tried
http://www.experts-exchange.com/Database/MySQL/Q_28031150.html
I got error

I locked root out and couldnt see my databases

mysql&amp;gt; update user set password=PASSWORD(&amp;quot;NEWPASSWORD&amp;quot;) where User=&amp;#39;USERNAME&amp;#39;;

I want to change my password to 
&amp;#39;pass&amp;#39;

mysql change password; without locking root out

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.