[mythtv-users] Capturecard names and multirec tuners

[Jay Foster]

On 4/4/19 9:12 PM, Stephen Worthington wrote:
>
> In any case, it was not there when I did it many years ago.  So what I
> did was to use SQL to directly edit the displayname fields in the
> database.  If you use one of the many GUI tools (eg Heidi SQL for
> Windows), it is not too difficult.  Or you can write a simple SQL
> script, for example, put this in a file "displaynames.sql":
>
> update capturecard set displayname='HDHR 1.1 (1)' where cardid=1;
> update capturecard set displayname='HDHR 1.2 (2)' where cardid=2;
> update capturecard set displayname='HDHR 2.1 (3)' where cardid=3;
>
> I leave the rest of the typing for you.  To run that script, do this:
>
> sudo mysql
> use mythconverg
> source displaynames.sql
>
>
>
I would like to do something similar to configure the channel icon files 
for all of my channels on all of my inputs.  There are several hundred 
of these and typing them in one by one in the backend setup is tedious 
and error prone.

However, I could not get past step 1 (sudo mysql).  Whether I use 'sudo 
mysql' or just 'mysql', I get an error, "ERROR 1045 (28000): Access 
denied for user 'root'@'localhost' (using password: NO)". Any idea how 
to get past this?

Jay