≡ Menu

HowTo: Mysql Update Password SQL Command

Fig.01: Mysql Updating / Changing password (click to enlarge)

The sql syntax is as follows and you must login as root (mysql server administrator) user account:

SET PASSWORD FOR 'user'@'host' = PASSWORD('password');

OR

UPDATE mysql.USER SET Password=PASSWORD('password') WHERE USER='user' AND Host='host';

You must flush the privileges

FLUSH PRIVILEGES;

Sysadmin because even developers need heroes!!!

Share this tutorial on:

Examples and usage: MySQL Change a User Password

{ 0 comments… add one }
Security: Are you a robot or human?
You can use these HTML tags and attributes: <strong> <em> <pre> <code> <a href="" title="">


   Tagged with: