resset root mysql password
step 1 : =>
sudo service stop mysql
sudo mkdir /var/run/mysqld
sudo chown mysql:mysql /var/run/mysqld
sudo mysqld_safe --skip-grant-tables
step 2 : =>
mysql -uroot
select User, host, authentication_string,plugin from mysql.user;
update mysql.user set authentication_string=PASSWORD('123456YOURPASSWORD') where user='root';
update mysql.user set plugin='mysql_native_password' where user='root';
FLUSH PRIVILEGES;
exit;
step 3 : =>
#kill pod
step 4 : =>
sudo service start mysql
+ Date: Mon 27 Apr 2020 | Time: | By: Javad Nasrollahi
|