My mythtv was failing on an update for “no password” for “root” user. I needed to find out what values the update script was using for the database username, hostname, and password. This link had a script listed to show these values. I will repeat the script below.
Put the following in a file, mark it as executable and run it. This will print the variables the mythtv-database upgrade script is using.
#!/bin/sh -e
/usr/share/debconf/confmodule
db_get mythtv/mysql_admin_user
admin_username=”$RET”
db_get mythtv/mysql_admin_password
admin_password=”$RET”
db_get mythtv/mysql_host
hostname=”$RET”
if test -z “$hostname”; then
hostname=localhost
fi
db_get mythtv/mysql_mythtv_dbname
database=”$RET”
echo “MythTV database upgrade variables (Debian):”
echo ” Username: $admin_username”
echo ” Password: $admin_password”
echo ” Hostname: $hostname”
echo ” Database: $database”