Answers for "mysql root user use native password"

mysql change root mysql_native_password

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

Posted by: Guest on December-11-2020

how to modify alter user root@localhost identified with mysql_native_password by properly

DELETE FROM mysql.user WHERE user='root' AND host='localhost';
FLUSH PRIVILEGES;

Posted by: Guest on January-06-2022

Code answers related to "mysql root user use native password"