How To Change Authentication Plugin Method in MySQL

Video Tutorial - https://youtu.be/jde2jn-fwBw

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

 

in This Tutorial you will learn " How To Change Authentication Plugin Method "auth_socket To mysql_native_password in MySQL "

MySQL is an open-source relational database management system.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mysql
Check Current Authentication plugin - select user,authentication_string,plugin,host FROM mysql.user;

alter user 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'NewPassword';
flush privileges;
select user,authentication_string,plugin,host FROM mysql.user;
exit
systemctl daemon-reload ; systemctl restart mysql 

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------