Change MySQL User Password

If your need to change the password of an existing MySQL user, follow these steps;

Log into MySQL

mysql -uroot

connect to the mysql table

use mysql;

change the password for the user (eg tom)

update user set password=PASSWORD("NEW-PASSWORD-HERE") where User='tom';

You can see what permissions a user has using this command

show grants for "tom";

or create a new user with

create user "tom" identified by "PASSWORD-HERE";
grant all on *.* to tom with grant option;

and finally, use drop to remove a user;

drop user "tom";