Setting the root password
From MyWiki
mysql> UPDATE mysql.user SET Password=PASSWORD('MyNewPass')
-> WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysqld_safe --skip-grant-tables &
mysql> use mysql;
mysql> update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
mysql> flush privileges;
mysql> quit
===
ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
MariaDB [mysql]> flush privileges;
ERROR 1146 (42S02): Table 'mysql.servers' doesn't exist
MariaDB [(none)]> show databases;
+-----------------------+
| Database |
+-----------------------+
| information_schema |
| artportfolio |
| bm_staff_data |
| community |
| gold |
| grad |
| learn_20120619 |
| learn_20130705 |
| learn_2014072101 |
| learn_gold_ac_uk |
| luns_moodle2_test |
| mahmoodle |
| moodle2 |
| moodle2_luns_20120725 |
| mysql |
| test |
+-----------------------+
16 rows in set (0.00 sec)