[mythtv-users] 14.04 clean
Mark Perkins
perkins1724 at hotmail.com
Sat Aug 2 22:21:06 UTC 2014
> 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.
More information about the mythtv-users
mailing list