[mythtv-users] 0.28 upgrade issue frontend connection

[Steve Greene]

Apparently, mysql keeps many of its internal permissions and settings in
the mysql table, which mythconverg will inherit.

On Sat, Jul 16, 2016 at 10:02 PM, Douglas Peale <Douglas_Peale at comcast.net>
wrote:

> $ mysql -uroot -prootpassword -e "select host,user from mysql.user"
> mysql: [Warning] Using a password on the command line interface can be
> insecure.
> +-----------+------------------+
> | host      | user             |
> +-----------+------------------+
> | %         | mythtv           |
> | localhost | debian-sys-maint |
> | localhost | mysql.sys        |
> | localhost | mythtv           |
> | localhost | root             |
> +-----------+------------------+
>
> Hmm. Is there a database called mysql?
> When I first ran the command steve green showed, I got an error about no
> database selected, so I used the command "USE
> mythconverg" I was assuming the user table would be in that database.
>
> Is my user table missing anything? If so, how do I add it?
>
> On 07/16/2016 06:44 PM, Mark Perkins wrote:
> > On 17 July 2016 8:44:24 AM ACST, Douglas Peale <
> Douglas_Peale at comcast.net> wrote:
> >> I am having a similar problem, so I went to look at the user table in
> >> mythconveg. I don't seem to have a user table.
> > What does this return from a terminal prompt on the backend (assuming it
> is also hosting your mysql database). Use your root mysql password:
> >
> > mysql -uroot -p -e "select host,user from mysql.user"
> >
> > If you really do have a 'mysql.users' table and not a 'mysql.user' table
> then that would be beyond me but i am not a mysql expert.
>
>
>
>
> _______________________________________________
> 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/20160716/81559f81/attachment.html>