[mythtv-users] New installation errors

[Dick Steffens]

On 09/16/2017 05:14 PM, Peter Bennett wrote:
>
>
> On 09/16/2017 06:39 PM, Dick Steffens wrote:
>> I'm still not able to configure the backend. Is it possibly because I 
>> installed MySQL myself before installing MythTV? If so, do I need to 
>> create the database and user in MySQL? If so, where can I find 
>> instructions on what to do?
>>
>> Thanks.
>> <--->
> If you installed from a package such as the ubuntu repository it 
> should have set up the database user id for you. 

Yes, I did, but no, it did not.

> In case it did not, or you installed manually, the instructions are here
> https://www.mythtv.org/wiki/Build_from_Source#MythTV_Database_Setup
> mysql -u root -p
> create database mythconverg;

There already was a mythconverg database. See below.

> create user 'mythtv'@'%' identified by 'mythtv';

I got an error message (now lost) when I tried this. I ran

select user, host from mysql.user;

and found that was a mythtv user at host %. I was not able to set a password for it
(as per a couple of lines down in the instructions), nor was I able to create user mythtv @ localhost, or set a password for it.
Probably being too clever, I dropped and recreated database mythconverg, and then
dropped user mythtv and recreated it. Then I was able to finish the rest of this set of instructions.

> create user 'mythtv'@'localhost' identified by 'mythtv';
> set password for 'mythtv'@'%' = password('mythtv');
> set password for 'mythtv'@'localhost' = password('mythtv');
> connect mythconverg;
> grant all privileges on *.* to 'mythtv'@'%' with grant option;
> grant all privileges on *.* to 'mythtv'@'localhost' with grant option;
> flush privileges;
> exit;

I ran

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql

It appeared to run normally, with the noted warnings seen on the 
instructions.

Next I ran mythbackend from the terminal. Lots of errors related to 
mythconverg being empty. I'm guessing that I shouldn't have dropped it 
and recreated it. An example error message is

Database error was:

Table 'mythconverg.settings' doesn't exist


Where can I find the instructions for creating the innards of mythconverg?

Or, is there something else I need to do?

Thanks for your help.

-- 
Regards,

Dick Steffens