mysql -u root -p

mysql "ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded"

sudo su

/etc/init.d/mysql stop
mysqld_safe --skip-grant-tables &
mysql -uroot

use mysql;

update user set password=PASSWORD("mynewpassword") where User='root';

update user set plugin="mysql_native_password";

quit;

/etc/init.d/mysql stop
kill -9 $(pgrep mysql)
/etc/init.d/mysql start

mysql -u root -p

/etc/init.d/mysql stop
sudo killall mysqld_safe
sudo killall mysqld
sudo mysqld_safe --skip-grant-tables &
mysql -u root
use mysql;
update user set password=PASSWORD("mynewpassword") where User='root';
update user set plugin="mysql_native_password";
quit;
/etc/init.d/mysql stop
sudo kill -9 $(pgrep mysql)
/etc/init.d/mysql start