Reset Root Password MariaDB on CentOS-7

root-reset

e.g. only
$ mysqld_safe --skip-grant-tables --skip-networking &
[1] 22411
# 140603 11:57:04 mysqld_safe Logging to syslog.
140603 11:57:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql



$ mysql -u root
mysql> use mysql;
mysql> update user set password=PASSWORD("new-password") where User='root';
mysql> flush privileges;
mysql> exit