[mythtv-users] database access

[backuppc at sundquist.imapmail.org]

Nick wrote:

Thanks for the suggestions.  Here are the results.

> Log in to MySQL as the root user and connect to the mysql database:
>
> $ mysql -u root -p mysql
> 
> First, see which host/user combos exist for user 'mythtv':
> 
> mysql> SELECT `Host`,`User`,`Password` FROM `user` WHERE `User` = 'mythtv';

I get:

mysql> SELECT `Host`,`User`,`Password` FROM `user` WHERE `User` = 'mythtv';
+-----------+--------+-------------------------------------------+
| Host      | User   | Password                                  |
+-----------+--------+-------------------------------------------+
| localhost | mythtv | *3ED1693E3543C9636CE5FCF00081E0B8FE0B3EC4 |
| %         | mythtv | *3ED1693E3543C9636CE5FCF00081E0B8FE0B3EC4 |
+-----------+--------+-------------------------------------------+
2 rows in set (0.00 sec)

mysql>


> Check to see if the password hashes are the same for all occurences of
> the mythtv user, and that you have any entry for localhost.

OK on that account

> Now show the users and hosts that are allowed to use the MythTV database:
> 
> mysql> SELECT `Host`,`User` FROM `db` WHERE `Db` = 'mythconverg';
> 
> Again, ensure you have an entry for localhost.

Once again, coming up roses:

mysql> SELECT `Host`,`User` FROM `db` WHERE `Db` = 'mythconverg';
+-----------+--------+
| Host      | User   |
+-----------+--------+
| %         | mythtv |
| localhost | mythtv |
+-----------+--------+
2 rows in set (0.01 sec)

mysql>

> I'm guessing that either you don't have privileges to connect from
> localhost as MySQL user 'mythtv' to the mythconverg database, or that
> the password for the user/host combo is not correct.

I'm still scratching my head.  This is quite strange.
 
> You might also check your my.cnf file to see if the MySQL server is
> bound to a particular hostname/IP. 

user at mythtv:~$ cat /etc/mysql/my.cnf | grep -v "#"

[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
skip-external-locking
bind-address            = 127.0.0.1
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 128K
thread_cache_size       = 8
query_cache_limit       = 1M
query_cache_size        = 16M
expire_logs_days        = 10
max_binlog_size         = 100M
skip-bdb

[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

[mysql]

[isamchk]
key_buffer              = 16M

!includedir /etc/mysql/conf.d/

user at mythtv:~$

So is bound to localhost, that's not the problem either.

Looking into the includedir:

user at mythtv:~$ cat /etc/mysql/conf.d/mythtv.cnf
[mysqld]
#bind-address=0.0.0.0
user at mythtv:~$

I checked if this was the problem by changing the bind-address in this file to 127.0.0.1 but that didn't change anything, even after rebooting.

So I am still stuck.  I appreciate the suggestions, though.

Jon S.