myql rm user


//=== https://dev.mysql.com/doc/refman/5.0/en/drop-user.html
* revoke privileges first
* then drop user ...

under mysql>

REVOKE INSERT ON *.* FROM 'jeffrey'@'localhost';

REVOKE all ON *.* FROM 'myrepl001'@'*';
drop user 'myrepl001'@'*';

REVOKE all ON *.* FROM 'myrepl7'@'172.31.*';
drop user 'myrepl7'@'172.31.*';

REVOKE all ON *.* FROM 'root'@'::1';
drop user 'root'@'::1';

REVOKE all ON *.* FROM 'root'@'e80eb84c57ae';
drop user 'root'@'e80eb84c57ae';

REVOKE all ON *.* FROM 'root'@'127.0.0.1';
drop user 'root'@'127.0.0.1';


//===
* change password for the current login user
mysql> set password= password('plaintext');

* change password for a certain user
(login as admin or root)

mysql> set password for 'u13'@'host26' = password('plaintext');