[mythtv-users] New installation errors
dick at dicksteffens.com
Sun Sep 17 01:16:21 UTC 2017
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?
> 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
> 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;
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
It appeared to run normally, with the noted warnings seen on the
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.
More information about the mythtv-users