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