[mythtv-users] db restore

[Daryl McDonald]

On Sun, Aug 5, 2018 at 12:25 PM, Ian Cameron <mkbloke at gmail.com> wrote:

> Let's start from the beginning.  What are the results when you:
>
> ls -la /etc/mysql
>
> and
>
> ls -la /etc/mythtv
>
> ?
>
> Also when you:
>
> sudo /bin/bash -c "echo \"select User,Host from user where User='mythtv'\"
> | mysql -uroot mysql"
>
> and
>
> sudo /bin/bash -c "echo \"select * from db where User='mythtv'\" | mysql
> -uroot mysql"
>
> ?
>
> Cheers, Ian
>
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org


 daryl at trieli:~$ ls -al /etc/mysql
total 40
drwxr-xr-x   4 root root  4096 Aug  5 09:20 .
drwxr-xr-x 137 root root 12288 Aug  5 09:22 ..
drwxr-xr-x   2 root root  4096 Aug  5 09:21 conf.d
-rw-------   1 root root   317 Aug  5 09:20 debian.cnf
-rwxr-xr-x   1 root root   120 Jul 27 13:58 debian-start
lrwxrwxrwx   1 root root    24 Aug  5 08:47 my.cnf ->
/etc/alternatives/my.cnf
-rw-r--r--   1 root root   839 Jan 21  2017 my.cnf.fallback
-rw-r--r--   1 root root   682 Feb  3  2017 mysql.cnf
drwxr-xr-x   2 root root  4096 Aug  5 09:21 mysql.conf.d
daryl at trieli:~$ ls -al /etc/mythtv
total 24
drwxr-xr-x   2 root   root    4096 Aug  5 09:21 .
drwxr-xr-x 137 root   root   12288 Aug  5 09:22 ..
-rw-rw----   1 mythtv mythtv   452 Aug  5 09:21 config.xml
-rw-r--r--   1 root   root    1110 Apr 13  2016 session-settings
daryl at trieli:~$ sudo /bin/bash -c "echo \"select User,Host from user where
User='mythtv'\" | mysql -uroot mysql"
[sudo] password for daryl:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
daryl at trieli:~$ sudo /bin/bash -c "echo \"select * from db where
User='mythtv'\" | mysql -uroot mysql
>

the final query seems to still be working
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20180805/2f6be935/attachment.html>