mysql change root password alter user code example

Example 1: mysql change user password

SET PASSWORD FOR 'user-name'@'localhost' = PASSWORD('NEW_USER_PASSWORD');FLUSH PRIVILEGES;

Example 2: mysql change root mysql_native_password

UPDATE
	mysql.user
SET
	plugin = 'mysql_native_password', 
	Password = PASSWORD('')
WHERE
	User = 'root';