[mythtv-users] db restore

[Daryl McDonald]

On Sun, Aug 5, 2018 at 12:35 PM, Daryl McDonald <darylangela at gmail.com>
wrote:

>
>
> 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
>
my bad, I missed the final | " | :
daryl at trieli:~$ sudo /bin/bash -c "echo \"select * from db where
User='mythtv'\" | mysql -uroot mysql"
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
daryl at trieli:~$
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20180805/4762058a/attachment.html>