alter user root mysql_native_password code example

Example 1: alter user mysql native password

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '<password>';

Example 2: mysql change root mysql_native_password

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