[mythtv-users] 0.28 upgrade issue frontend connection

[Steve Greene]

My working installation reads as follows

> mysql> SELECT user,host FROM user;
> +------------------+-------------+
> | user             | host        |
> +------------------+-------------+
> | mythtv           | %           |
> | root             | 127.0.0.1   |
> | mythtv           | 192.168.1.0 |
> | root             | ::1         |
> | root             | bilbo       |
> | debian-sys-maint | localhost   |
> | mythtv           | localhost   |
> | root             | localhost   |
> +------------------+-------------+
> 8 rows in set (0.00 sec)
>
>

On Sat, Jul 16, 2016 at 10:08 PM, Steve Greene <sgreene59 at verizon.net>
wrote:

> 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/57ca59d5/attachment.html>