[mythtv-users] db restore

[Ian Cameron]

Do you have a user and password showing in debian.cnf if you:

sudo cat /etc/mysql/debian.cnf?

Don't copy this to the list.

If so, try the commands again using those parameters, i.e.:

sudo /bin/bash -c "echo \"select User,Host from user where User='mythtv'\"
| mysql -u<username> -p<password> mysql"

and

sudo /bin/bash -c "echo \"select * from db where User='mythtv'\" | mysql
-u<username> -p<password> mysql"

substituting <username> and <password> with the values shown in debian.cnf.

Cheers, Ian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20180805/04101f71/attachment.html>