[mythtv-users] 0.28 upgrade issue frontend connection

[Douglas Peale]

$ 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.



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