[mythtv-users] Password error on optimize_mythdb.pl

[Jay Harbeston (ISeePeople)]

> On Feb 25, 2018, at 7:15 PM, Don Brett <dlbrett at zoominternet.net> wrote:
> 
> On 2/25/2018 4:09 PM, Peter Bennett wrote:
>> 
>> 
>> On 02/24/2018 11:49 PM, Don Brett wrote:
>>> Not sure where this leaves us....
>>> 
>>> -All of the /home and config.xml issues you mentioned appear to be setup correctly.  It's using the same name/password/database name as the contrib example has, so it's pretty standard.
>>> 
>>> Anything else to try?
>>> 
>>> Don
>>> 
>>> PS - Thanks for  the  help.
>>> 
>>> 
>> What user id are you logged in as when running mythdb.pl?
>> Make sure that user has a $HOME/.mythtv directory with the correct config.xml.
>> Get rid of mysql.txt, you should not use that any more.
>> Test from the user that is running mythdb.pl whether you can connect to mysql with the user id and password that are in the $HOME/.mythtv/config.xml file
>> For example
>> mysql -u mythtv -p9uKbDz3G -h localhost mythconverg
>> 
>> 
> 
>  Can someone check your working instance?
> 
> 
Maybe what is needed is using the option 

 --login-path=local              ## This option will require some setup of mysql/mariadb.

when in perl.  I had to do this when I upgraded to latest mysql/mariadb a year or so ago.

Other than that suggestion, I don’t know.
Regards,

Jay



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20180225/b58eb37c/attachment.html>