MythTV cannot connect to database

For discussion of topics specific to MythTV on OSX
pgarrity18
Newcomer
Posts: 7
Joined: Wed Nov 26, 2014 3:04 pm
United States of America

Re: MythTV cannot connect to database

Post by pgarrity18 » Wed Nov 26, 2014 10:36 pm

It looks like
I had it working, I just needed to change the ip address from 192.168.1.6 to localhost and it seems to be ok.

Front end seems to work so I guess this issue can be closed out from my end anyway. Not sure if the OP figured out his issue.

Thanks a lot for the help!

User avatar
pvr4me
Senior
Posts: 627
Joined: Fri Feb 07, 2014 7:25 pm
Location: near Toronto, Canada
Contact:
Canada

Re: MythTV cannot connect to database

Post by pvr4me » Thu Nov 27, 2014 1:18 am

pgarrity18 wrote:I should mention that I am now in the process of building the macport
Wait, what!?! For the sake of others--DON'T DO THIST!! Mixing the installer and building your own software with MacPorts is NOT a supported configuration. See http://www.mythtv.org/wiki/MacPorts#Download_or_build

What made you think this would help?
but here is what I get...

Code: Select all

+-------------------------------------------------------------------------------------------------------+
| Grants for mythtv@%                                                                                   |
+-------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'mythtv'@'%' IDENTIFIED BY PASSWORD '*CC8F35F587CA5A556B4132C2407E556D92172FFC' |
| GRANT ALL PRIVILEGES ON `mythconverg`.* TO 'mythtv'@'%'                                               |
+-------------------------------------------------------------------------------------------------------+
This proves that your database was properly initialized but that doesn't matter anymore.

Hopefully your installation won't blow up when you update Myth, and/or its dependencies, in the future.

Craig
The MacPorts guy.

headrc
Newcomer
Posts: 8
Joined: Fri Jan 02, 2015 1:43 am
United States of America

Re: MythTV cannot connect to database

Post by headrc » Sat Jan 03, 2015 6:38 am

Ditto on this problem. I just posted my own plea for help. Seems like Myth is pretty hard to get setup.

User avatar
stuartm
Developer
Posts: 125
Joined: Wed Feb 05, 2014 5:17 pm
Great Britain

Re: MythTV cannot connect to database

Post by stuartm » Wed Feb 11, 2015 9:02 am

Mysql defaults to not listening on external (non-loopback) IP addresses. Check my.cnf for the skip-networking option, if it's there remove or comment it.

Also check /opt/local/etc/mysql55/macports-default.cnf for the same option.

Post Reply