You may want to change the password for Mythtv, especially that when Mythtv is first installed it auto generates a generic password to connect the front end to the back-end, connect to the database, and for the Mythweb to connect to the database. Fortunately all of these share the same password. The auto generated generic password could be troublesome, so here is how to change it. I will explain on how to change these passwords using ssh. Ssh should be ready for use on the Mythtv box first.
Changing Mysql Password
First the password should be changed for the Mysql database. open ssh terminal. These following commands will change the mysql password to “mythtv”:
# mysql -u root -p mysql
myqsl> GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'localhost' IDENTIFIED BY 'mythtv' WITH GRANT OPTION;
mysql> UPDATE user SET Password=PASSWORD('mythtv') WHERE user='mythtv';
mysql> FLUSH PRIVILEGES;
mysql> quit
Changing Mythweb Password To Match
Now that the database password has been changed, lets change the password for mythweb. In ssh terminal edit the mythweb.conf file. I preffer nano.
# sudo nano /etc/apache2/sites-available/mythweb.conf
Find the spot in the file where it says “setenv db_password”. You will see the old password. Change it to “mythtv” so that it matches the database password.
Reboot Mythtv, then change the passwords on any front ends or devices to “mythtv” as needed.