Reset MySQL/MariaDB Root Password
Step 1:
Stop MySQL/MariaDB Service
CentOS/RHEL 7 Ubutu 16
systemctl stop mysqld/mariadb
CentOS/RHEL 6/5 Ubuntu 14
service mysqld stop
Step 2:
Start the MySQL daemon with “ mysqld_safe”
mysqld_safe –skip-grant-tables
Press CTRL+z to suspend a process by sending it the signal SIGSTOP
Step 3 :
Login DATABASE without Password
mysql --user=root mysql
Step 4 :
Update Root Password
update user set Password=PASSWORD('new-password') where user='root';
OR
set password for ‘root’@’localhost’=password(‘new-password’);
flush privileges;
exit;
Step 5:
kill all mysql Process and restart mysql/mariadb service
pkill -9 myslqd
systemctl restart myslq/mariadb
CentOS/RHEL 7, Ubuntu 16
service mysqld/mariadb restart.
