[mythtv-users] 0.28 upgrade issue frontend connection

[Mark Perkins]

> -----Original Message-----
> From: Douglas Peale [mailto:Douglas_Peale at comcast.net]
> Sent: Sunday, 17 July 2016 12:49 PM
> To: Mark Perkins <perkins1724 at hotmail.com>; Discussion about MythTV
> <mythtv-users at mythtv.org>
> Subject: Re: [mythtv-users] 0.28 upgrade issue frontend connection
> 
> $ mysql -uroot -pb0RhwvPj -e "show grants for 'mythtv'@'%'"
> mysql: [Warning] Using a password on the command line interface can be
> insecure.
> +---------------------------------------------------------+
> | Grants for mythtv@%                                     |
> +---------------------------------------------------------+
> | GRANT USAGE ON *.* TO 'mythtv'@'%'                      |
> | GRANT ALL PRIVILEGES ON `mythconverg`.* TO 'mythtv'@'%' |
> +---------------------------------------------------------+
> 
> 
Douglas by the book that should be fine so lets leave as is for now and try a few other things. Lets confirm passwords are correct. Run the following command to re-update password for mythtv user in mysql:

mysql -uroot -p -e "set password for 'mythtv'@'%'='your_desired_mythtv_password'"

Where your_desired_mythtv_password should be the same as that in your config.xml file (normally stored in ~/.mythtv of the user running your backend but I am not particularly familiar with Mint). Now lets see if we can access from the machine hosting your backend (assuming your mysql server is on your backend):

mysql -umythtv -pyour_desired_mythtv_password -e "select * from mythconverg.settings where value='BackendServerIP'"

If that fails lets check what is listening on port 3306 by running this command on the backend as the root user:

netstat -peanut | grep 3306

Have you checked for bind_address values in your mysql config files? I don't know what their location will be in Mint but at a start you are probably looking for my.cnf and/or mythtv.cnf. Try /etc/mysql/mysql.cnf and /etc/mysql/mysql.conf.d/mythtv.cnf. If nothing at those locations try:

find /etc -name my.cnf

In the first instance we should be able to see what mysql is binding to from the netstat command above anyway.