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)