[mythtv-users] 0.28 upgrade issue frontend connection

[Douglas Peale]

$ mysql -uroot -pb0RhwvPj -e "show grants for 'mythtv'@'%'"
mysql: [Warning] Using a password on the command line interface can be insecure.
+---------------------------------------------------------+
| Grants for mythtv@%                                     |
+---------------------------------------------------------+
| GRANT USAGE ON *.* TO 'mythtv'@'%'                      |
| GRANT ALL PRIVILEGES ON `mythconverg`.* TO 'mythtv'@'%' |
+---------------------------------------------------------+


On 07/16/2016 07:55 PM, Mark Perkins wrote:
> On 17 July 2016 11:32:06 AM ACST, 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?
>>
> Lets check the grants. Douglas run this command from terminal:
>
> mysql -uroot -p -e "show grants for 'mythtv'@'%'"
>
> Steve should run the following two commands:
> mysql -uroot -p -e "show grants for 'mythtv'@'%'"
> mysql -uroot -p -e "show grants for 'mythtv'@'192.168.1.2'"
>
> Watch at the end for the single quotation mark ' character followed by double quotation mark character ".
>
>


-------------- 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/d9a717ae/attachment.sig>