<div dir="ltr"><div dir="ltr">ok, I got a bit further, the root mysql problem, I fixed like this:<br><div>(Found the steps from a page, but dont have the URL handy)<br></div><div>(Also set a Linux User root password before)<br></div><div><ol><li>Stop MySQL</li></ol>
<pre id="gmail-intended"> sudo service mysql stop
</pre>
<ol><li>Make MySQL service directory.</li></ol>
<pre id="gmail-intended"> sudo mkdir /var/run/mysqld
</pre>
<ol><li>Give MySQL user permission to write to the service directory.</li></ol>
<pre id="gmail-intended"> sudo chown mysql: /var/run/mysqld
</pre>
<ol><li>Start MySQL manually, without permission checks or networking.</li></ol>
<pre id="gmail-intended"> sudo mysqld_safe --skip-grant-tables --skip-networking &
</pre>
<ol><li>Log in without a password.</li></ol>
<pre id="gmail-intended"> mysql -uroot mysql<br><br></pre><pre id="gmail-intended"><b>Now reset authentication and set password resolving to default mechanism:</b><br><br>
<code><span class="gmail-kwd">use</span><span class="gmail-pln"> mysql</span><span class="gmail-pun">;</span><span class="gmail-pln"> </span><span class="gmail-pun">#</span><span class="gmail-pln"> </span><span class="gmail-kwd">use</span><span class="gmail-pln"> mysql </span><span class="gmail-kwd">table</span><span class="gmail-pln">
</span><span class="gmail-kwd">update</span><span class="gmail-pln"> </span><span class="gmail-kwd">user</span><span class="gmail-pln"> </span><span class="gmail-kwd">set</span><span class="gmail-pln"> authentication_string</span><span class="gmail-pun">=</span><span class="gmail-pln">PASSWORD</span><span class="gmail-pun">(</span><span class="gmail-str">""</span><span class="gmail-pun">)</span><span class="gmail-pln"> </span><span class="gmail-kwd">where</span><span class="gmail-pln"> </span><span class="gmail-kwd">User</span><span class="gmail-pun">=</span><span class="gmail-str">'root'</span><span class="gmail-pun">;</span><span class="gmail-pln"> </span><span class="gmail-pun">#</span><span class="gmail-pln"> </span><span class="gmail-kwd">update</span><span class="gmail-pln"> password </span><span class="gmail-kwd">to</span><span class="gmail-pln"> nothing
</span><span class="gmail-kwd">update</span><span class="gmail-pln"> </span><span class="gmail-kwd">user</span><span class="gmail-pln"> </span><span class="gmail-kwd">set</span><span class="gmail-pln"> plugin</span><span class="gmail-pun">=</span><span class="gmail-str">"mysql_native_password"</span><span class="gmail-pln"> </span><span class="gmail-kwd">where</span><span class="gmail-pln"> </span><span class="gmail-kwd">User</span><span class="gmail-pun">=</span><span class="gmail-str">'root'</span><span class="gmail-pun">;</span><span class="gmail-pln"> </span><span class="gmail-pun">#</span><span class="gmail-pln"> </span><span class="gmail-kwd">set</span><span class="gmail-pln"> password resolving </span><span class="gmail-kwd">to</span><span class="gmail-pln"> </span><span class="gmail-kwd">default</span><span class="gmail-pln"> mechanism </span><span class="gmail-kwd">for</span><span class="gmail-pln"> root </span><span class="gmail-kwd">user</span><span class="gmail-pln">
flush privileges</span><span class="gmail-pun">;</span><span class="gmail-pln">
quit</span><span class="gmail-pun">;</span></code>
<br>----<br><br></pre><pre id="gmail-intended">So now I am able to access the mysql ddatabase as root user:<br><br>miro@mythbox:~$ <b>sudo mysql -u root mythconverg</b><br>Reading table information for completion of table and column names<br>You can turn off this feature to get a quicker startup with -A<br><br>Welcome to the MySQL monitor. Commands end with ; or \g.<br>Your MySQL connection id is 4<br>Server version: 5.7.26-0ubuntu0.16.04.1 (Ubuntu)<br><br>Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.<br><br>Oracle is a registered trademark of Oracle Corporation and/or its<br>affiliates. Other names may be trademarks of their respective<br>owners.<br><br>Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.<br><br>mysql> show tables;<br>+--------------------------------+<br>| Tables_in_mythconverg |<br>+--------------------------------+<br>| archiveitems |<br>| bdbookmark |<br>| callsignnetworkmap |<br>| capturecard |<br>| cardinput |<br>| channel |<br>| channelgroup |<br>| channelgroupnames |<br></pre><pre id="gmail-intended">ooo <br></pre><pre id="gmail-intended"><br><br></pre><pre id="gmail-intended"><b><font size="6">And now my mythtv browser GUI works again !!! hooray</font></b><br></pre>
</div></div></div><div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br> <table style="border-top:1px solid #d3d4de">
<tr>
<td style="width:55px;padding-top:18px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
<td style="width:470px;padding-top:17px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virenfrei. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank" style="color:#4453ea">www.avast.com</a> </td>
</tr>
</table>
<a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Am Fr., 10. Mai 2019 um 11:16 Uhr schrieb Miroslav Pavlovic <<a href="mailto:mail.pavlovic@gmail.com">mail.pavlovic@gmail.com</a>>:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr"><div>Thanks for your Support, but still not fixed and same Error comes up.</div><div>I've set the root password, see below some command line output.</div><div><br></div><div>BR./Miro</div><div><br></div><div>miro@mythbox:~$ sudo su -<br>[sudo] password for miro:<br>root@mythbox:~#<br>root@mythbox:~# passwd<br>Enter new UNIX password:<br>Retype new UNIX password:<br>passwd: password updated successfully<br>root@mythbox:~#<br>root@mythbox:~# exit<br>logout<br>miro@mythbox:~$ su -<br>Password:<br>root@mythbox:~#<br>root@mythbox:~#<br>root@mythbox:~# exit<br>logout<br>miro@mythbox:~$<br>miro@mythbox:~$ sudo mysql -u root -p mythconverg<br>Enter password:<br>ERROR 1524 (HY000): Plugin 'mysqlnativepassword' is not loaded<br>miro@mythbox:~$<br><br></div></div></div><div id="gmail-m_-658443965015245527DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br> <table style="border-top:1px solid rgb(211,212,222)">
<tbody><tr>
<td style="width:55px;padding-top:18px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" style="width: 46px; height: 29px;" width="46" height="29"></a></td>
<td style="width:470px;padding-top:17px;color:rgb(65,66,78);font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virenfrei. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" style="color:rgb(68,83,234)" target="_blank">www.avast.com</a> </td>
</tr>
</tbody></table>
<a href="#m_-658443965015245527_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Am Fr., 10. Mai 2019 um 04:40 Uhr schrieb Stephen Worthington <<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>>:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">On Thu, 9 May 2019 21:33:14 +0100, you wrote:<br>
<br>
>On 09/05/2019 17:18, Stephen Worthington wrote:<br>
>> On Thu, 9 May 2019 17:05:59 +0200, you wrote:<br>
>> <br>
>>> I can log in to the DB using the mythtv User, but not able as root. I dont<br>
>>> have the password and also getting the below Error.<br>
>>><br>
>>> miro@mythbox:/etc/mythtv$ sudo mysql -u root mythconverg<br>
>>> ERROR 1524 (HY000): Plugin 'mysqlnativepassword' is not loaded<br>
>>> miro@mythbox:/etc/mythtv$ sudo mysql -u root<br>
>>> ERROR 1524 (HY000): Plugin 'mysqlnativepassword' is not loaded<br>
>>> miro@mythbox:/etc/mythtv$<br>
>> <br>
>> I have never met that problem before, but try it looks like it is<br>
>> trying to get the root password from the operating system and does not<br>
>> have the plugin to do that. So try with -p and it should ask for the<br>
>> root password:<br>
>> <br>
>> sudo mysql -u root -p mythconverg<br>
>> <br>
>> And if that does not work try just:<br>
>> <br>
>> sudo mysql<br>
>> <br>
>> If that fails, there used to be an obscure bug with caching of<br>
>> passwords, the easiest fix for which is to restart MySQL (or reboot):<br>
>> <br>
>> sudo systemctl restart mysql<br>
>> <br>
>> If you do not have a root password set, use this command to set it:<br>
>> <br>
>> sudo passwd<br>
>> <br>
>Actually, it is complaining about the *mysql* password. To access mysql, any user should be able to <br>
>do that. sudo is not required here.<br>
><br>
>I would assume that the root password for mysql/mariadb was requested during the installation <br>
>procedure. Whenever I have built a clean Debian system with mysql, that is one of the steps that <br>
>happens along the way.<br>
<br>
Yes, setting the MySQL user and password for the mythconverg database<br>
should happen on MythTV install in a clean setup. That does not work<br>
though, if you then restore from an old system and copy across the old<br>
config.xml which will have a different password. Since you can not<br>
normally set MySQL passwords using the MythTV credentials, and MySQL<br>
on a clean system has no other login credentials, you then need to use<br>
the root password (the system root password, not the MySQL one) to<br>
access MySQL to do the GRANT commands needed.<br>
<br>
And if you have not set the (system) root password, you probably need<br>
to do that before you can use root to run the mysql command. Since I<br>
always set the root password as soon as I boot into a clean system, I<br>
have never tried to run mysql from root without a root password set.<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
</blockquote></div>
</blockquote></div>