[mythtv-users] Getting GUI Error message, when opening the MythTV Browser page.

[Miroslav Pavlovic]

Thanks for your Support, but still not fixed and same Error comes up.
I've set the root password, see below some command line output.

BR./Miro

miro at mythbox:~$ sudo su -
[sudo] password for miro:
root at mythbox:~#
root at mythbox:~# passwd
Enter new UNIX password:
Retype new UNIX password:
passwd: password updated successfully
root at mythbox:~#
root at mythbox:~# exit
logout
miro at mythbox:~$ su -
Password:
root at mythbox:~#
root at mythbox:~#
root at mythbox:~# exit
logout
miro at mythbox:~$
miro at mythbox:~$ sudo mysql -u root -p mythconverg
Enter password:
ERROR 1524 (HY000): Plugin 'mysqlnativepassword' is not loaded
miro at mythbox:~$


<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virenfrei.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Am Fr., 10. Mai 2019 um 04:40 Uhr schrieb Stephen Worthington <
stephen_agent at jsw.gen.nz>:

> On Thu, 9 May 2019 21:33:14 +0100, you wrote:
>
> >On 09/05/2019 17:18, Stephen Worthington wrote:
> >> On Thu, 9 May 2019 17:05:59 +0200, you wrote:
> >>
> >>> I can log in to the DB using the mythtv User, but not able as root. I
> dont
> >>> have the password and also getting the below Error.
> >>>
> >>> miro at mythbox:/etc/mythtv$ sudo mysql -u root mythconverg
> >>> ERROR 1524 (HY000): Plugin 'mysqlnativepassword' is not loaded
> >>> miro at mythbox:/etc/mythtv$ sudo mysql -u root
> >>> ERROR 1524 (HY000): Plugin 'mysqlnativepassword' is not loaded
> >>> miro at mythbox:/etc/mythtv$
> >>
> >> I have never met that problem before, but try it looks like it is
> >> trying to get the root password from the operating system and does not
> >> have the plugin to do that.  So try with -p and it should ask for the
> >> root password:
> >>
> >> sudo mysql -u root -p mythconverg
> >>
> >> And if that does not work try just:
> >>
> >> sudo mysql
> >>
> >> If that fails, there used to be an obscure bug with caching of
> >> passwords, the easiest fix for which is to restart MySQL (or reboot):
> >>
> >> sudo systemctl restart mysql
> >>
> >> If you do not have a root password set, use this command to set it:
> >>
> >> sudo passwd
> >>
> >Actually, it is complaining about the *mysql* password. To access mysql,
> any user should be able to
> >do that. sudo is not required here.
> >
> >I would assume that the root password for mysql/mariadb was requested
> during the installation
> >procedure. Whenever I have built a clean Debian system with mysql, that
> is one of the steps that
> >happens along the way.
>
> Yes, setting the MySQL user and password for the mythconverg database
> should happen on MythTV install in a clean setup.  That does not work
> though, if you then restore from an old system and copy across the old
> config.xml which will have a different password.  Since you can not
> normally set MySQL passwords using the MythTV credentials, and MySQL
> on a clean system has no other login credentials, you then need to use
> the root password (the system root password, not the MySQL one) to
> access MySQL to do the GRANT commands needed.
>
> And if you have not set the (system) root password, you probably need
> to do that before you can use root to run the mysql command.  Since I
> always set the root password as soon as I boot into a clean system, I
> have never tried to run mysql from root without a root password set.
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20190510/56811a94/attachment-0001.html>