[mythtv-users] 0.28 upgrade issue frontend connection

[Douglas Peale]

mysql> SELECT host,user FROM user;
+-----------+------------------+
| host      | user             |
+-----------+------------------+
| %         | mythtv           |
| localhost | debian-sys-maint |
| localhost | mysql.sys        |
| localhost | mythtv           |
| localhost | root             |
+-----------+------------------+
5 rows in set (0.00 sec)

Doesn't seem any different from the command mark perkens asked me to run.

On 07/16/2016 06:51 PM, Steve Greene wrote:
> start with use mysq;, then SELECT host,user FROM user
>
> I think you should be looking at mysql permissions, not just those related to your backend database.
>
> Steve
>
> On Sat, Jul 16, 2016 at 9:44 PM, Mark Perkins <perkins1724 at hotmail.com <mailto:perkins1724 at hotmail.com>> wrote:
>
>     On 17 July 2016 8:44:24 AM ACST, Douglas Peale <Douglas_Peale at comcast.net <mailto: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.
>     --
>     Sent from mobile device. Please excuse brevity.
>     _______________________________________________
>     mythtv-users mailing list
>     mythtv-users at mythtv.org <mailto: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
>
>
>
>
> _______________________________________________
> 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/0aba5af8/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160716/0aba5af8/attachment.sig>