Answers for "change user root plugin mysql"

SQL
1

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
0

mysql user set plugin

mysql> UPDATE mysql.user SET plugin = 'mysql_native_password', authentication_string = PASSWORD('changeme') WHERE User = 'root';
mysql> FLUSH PRIVILEGES;
Posted by: Guest on January-17-2021

Code answers related to "change user root plugin mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language