[mythtv-users] 14.04 clean

[Mark Perkins]

> On 3 Aug 2014, at 6:02 am, "Daryl McDonald" <darylangela at gmail.com> wrote:
> 
> Greetings mythizens, I need help getting over the first hurdle of a clean install of myth on 14.04. After searching the error I got in the database setup I followed directions which resulted in the following:
> 
> daryl at daryl-A780L3C:~$ mysql -u root -p
> Enter password: 
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 162
> Server version: 5.5.38-0ubuntu0.14.04.1 (Ubuntu)
> 
> Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
> 
> Oracle is a registered trademark of Oracle Corporation and/or its
> affiliates. Other names may be trademarks of their respective
> owners.
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
> 
> mysql>  create user 'mythtv'@'%' identified by 'mythtv';
> ERROR 1396 (HY000): Operation CREATE USER failed for 'mythtv'@'%'
> mysql> create user 'mythtv'@'localhost' identified by 'mythtv';
> ERROR 1396 (HY000): Operation CREATE USER failed for 'mythtv'@'localhost'
> mysql>  connect mythconverg;
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
> 
> Connection id:    163
> Current database: mythconverg
> 
> mysql> grant all privileges on *.* to 'mythtv'@'%' with grant option;
> Query OK, 0 rows affected (0.00 sec)
> 
> mysql>  grant all privileges on *.* to 'mythtv'@'localhost' with grant option;
> Query OK, 0 rows affected (0.00 sec)
> 
> mysql> flush privileges;
> Query OK, 0 rows affected (0.00 sec)
> 
> mysql> exit
> Bye
> 
> What am I missing/ / What can I do next? its a loop when I try to set up the BE and I can't get into the deep settings, just the first couple pages and then back to the country of origin screen.
> 
> TIA Daryl
> 
> _______________________________________________

Daryl, it appears that the create user commands failed.

Inside MySQL can you run the following command and post the results?

select user, host from mysql.user;

Want to check if the MythTV user exists in MySQL or not.

You may need to also set passwords if not already done?

A sequence of steps like this may work (inside MySQL):

flush privileges;
create user 'mythtv'@'%' identified by 'mythtv';
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;


Also, I don't know why but I had to create MythTV users on hosts 127.0.0.% and 192.168.0.% (substitute your own IP address setup here) - for some reason '%' by itself just didn't work for me.

Ie add in the appropriate point in the above sequence of steps:

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

Make sure to replace '192.168.0.%' with numbering appropriate to your network if you use different numbering.

My understanding is that '%' acts as a wildcard therefore a host of '%' should match any host but was not sufficient in my case. In my case it had to be slightly more specific.