[mythtv-users] How to automate a mysql script with a password protected database?

[Bruce Smith]

> # Command to return the sql rows. Must have -N !!A 
> $MYSQL="mysql -N -u root -p mythconverg"; 
> $SQL="select chanid, starttime, endtime, title, subtitle from recorded order
> by starttime"; 
> 
> $data=`echo $SQL | $MYSQL`; 
> ----------
> I have tried various things like
> -p mypass
> -p 'mypass'

> etc but no joy. I am hoping someone with more sql background can point me in
> the right direction.

Try getting rid of the space:   -pmypass

 - BS