mysqladmin -u root password newpassword
change or update root password
mysqladmin -u root -p ‘oldpassword’ password ‘newpassword’
MySQL Grant Privileges
CREATE USER ‘username’@’localhost’ IDENTIFIED BY ‘newpassword’; GRANT ALL PRIVILEGES ON database.* ‘username’@’localhost’ WITH GRANT OPTION;