<div dir="ltr"><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Sep 19, 2017 at 8:25 PM, Daryl McDonald <span dir="ltr"><<a href="mailto:darylangela@gmail.com" target="_blank">darylangela@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Trying to get the android frontend to connect to the database I did this:<div><br></div><div><pre><code>mysql -u root -p mysql
mysql> grant all on mythconverg.* to 'mythtv'@'%' identified by 'passwd';
mysql> flush privileges;
mysql> exit;</code></pre><pre>and now I can't connect to the BE on the combined box (16.04/0.28) and trying to restore a database results in this:</pre><pre>trieli@mythtv:~$ <a href="http://mythconverg_restore.pl" target="_blank">mythconverg_restore.pl</a> --drop_database --create_database --filename mythconverg-1344-<wbr>20170919104850.sql.gz --verbose
Configuring environment:
- username: trieli
- HOME: /home/trieli
- MYTHCONFDIR: /home/trieli/.mythtv
Parsing configuration files:
- checking: /home/trieli/.mythtv/config.<wbr>xml
parsing: /home/trieli/.mythtv/config.<wbr>xml
- checking: /home/trieli/.mythtv/backuprc
parsing: /home/trieli/.mythtv/backuprc
Applying command-line arguments.
Checking configuration.
Database Information:
DBHostName: localhost
DBPort: 3306
DBUserName: mythtv
DBPassword: XXX
DBName: mythconverg
DBSchemaVer:
DBBackupDirectory: /media/storage/mythtv/db_<wbr>backups
DBBackupFilename: mythconverg-1344-<wbr>20170919104850.sql.gz
drop_database: yes
create_database: yes
Executables:
mysql_client: mysql
uncompress: gzip -d
Miscellaneous:
partial_restore: no
restore_xmltvids: no
change_hostname: no
Checking database.
Preparing initial database.
Unable to connect to database.
database: mythconverg
host: localhost
username: mythtv
password: 7HVMRTtn
Please check your configuration files to verify the database connection
information is correct. The files that are used to retrieve connection
information are prefixed with "parsing" in the "Parsing configuration files"
section of the --verbose output.
Also note that any [client] or [mysql] password specified in the MySQL options
file (/etc/my.cnf or /etc/mysql/my.cnf or ~/.my.cnf) will take precedence over
the password specified in the MythTV configuration files.
ERROR: Unable to connect to database.
trieli@mythtv:~$ <br></pre><pre>Please help! thanks in advance Daryl</pre></div></div>
<br></blockquote><div><br></div><div><div><div>I'm not sure, but I think you set your mysql mythconverg password to
'passwd'. You could change this in your /home/trieli/.mythtv/config.xml
file (put 'passwd' instead of '7HVMRTtn').<br><br></div>There is definitely a way to set the password to
your other password (7HVMRTtn) but I don't know specifics on that. I
usually roll with just mythtv as my password.<br></div><div><br></div>Having
'passwd' as your password would probably be fine, but if that bothers
you, someone will probably pipe in with the mysql command to change it.
You can probably look that up yourself.</div><div><br></div><div>Jerry<br></div></div></div></div>