Manually change wordpress password via SQL

<pre class="wp-block-syntaxhighlighter-code">UPDATE <code>wp_users</code> SET <code>user_pass</code> = MD5('intended_pw') WHERE <code>wp_users</code>.<code>ID</code> = 1;</pre>