Re: mythtv cannot connect to database
Posted: Tue Jul 09, 2019 3:52 pm
So this is what I did:
Entered "bind-address = [local network address]" into /etc/mysql/mariadb.conf.d/60-mythtv.cnf.
Put the hostname instead of "localhost" into all mythtv config.xml.
Tried mysql -u mythtv -p mythconverg -h [hostname] and got a "connection denied", because now I am no longer connecting as mythtv@localhost but as mythtv@hostname.mynetwork.
Created the user mythtv@hostname.mynetwork in mariadb and gave it the same privileges and same password as mythtv@localhost had.
Now I can connect with mysql.
After a restart the mythtv-backend service comes up flawlessly, and the frontend works, too.
Thank you!
P.S.: I am going to file a bug report with mariadb.
They can't really call this a feature...
Entered "bind-address = [local network address]" into /etc/mysql/mariadb.conf.d/60-mythtv.cnf.
Put the hostname instead of "localhost" into all mythtv config.xml.
Tried mysql -u mythtv -p mythconverg -h [hostname] and got a "connection denied", because now I am no longer connecting as mythtv@localhost but as mythtv@hostname.mynetwork.
Created the user mythtv@hostname.mynetwork in mariadb and gave it the same privileges and same password as mythtv@localhost had.
Now I can connect with mysql.
After a restart the mythtv-backend service comes up flawlessly, and the frontend works, too.
Thank you!
P.S.: I am going to file a bug report with mariadb.
They can't really call this a feature...