You are not logged in.
I'm having big problems that I can't solve with my mysql install. I'm running the most current mysql packages, and trying to install mythtv on top of it.
I can install and run my mythbackend script no problem as long as I use localhost as the parameter for backend connections. As soon as I try to use my IP address in .mythtv/mysql.txt I get the following error:
[mythtv@mythtv .mythtv]$ mythbackend
2006-10-11 00:34:01.871 Using runtime prefix = /usr/local
2006-10-11 00:34:01.881 New DB connection, total: 1
2006-10-11 00:34:01.886 Unable to connect to database!
2006-10-11 00:34:01.887 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'mythtv' (using password: YES)
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-10-11 00:34:01.942 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2006-10-11 00:34:01.997 Failed to init MythContext, exiting.
[mythtv@mythtv .mythtv]$
I made sure I had skip-networking commented out in my /etc/my.cnf file,
I see from some posts that tcpwrappers is a potential pitfall, so I checked my hosts/deny/allow files and they are as follows:
#
# /etc/hosts.allow
#
sshd: 192.168.123.0/255.255.255.0
mysqld: 192.168.123.0/255.255.255.0
mysqld-max : ALL : ALLOW
# End of file
#
# /etc/hosts.deny
#
ALL: ALL: DENY
# End of file
Does anyone have any ideas? I have been through ALL of the mysql help site at http://dev.mysql.com/doc/refman/5.0/en/ … enied.html
and nothing seems to work. I'm completely stumped and I'd like to get this working, as I use a remote connection on my internal net to connect to the mysql database for mythtv usage, and this is preventing it.
Thanks in advance.
Mark
Offline
Hi 86turbodsl,
try with this:
within mysql command prompt assign permissions to mythtv user:
grant all privileges on <dbname>.* to 'mythtv'@'mythtv' identified by '<user>'
Offline
Ok, this is what I entered:
mysql> grant all privileges on mythconverg.* to 'mythtv'@'%' identified by 'mythtv';
mysql> flush privileges;
I changed to % for hostname so I could get on anywhere.
This is my output when running mythbackend:
[mythtv@mythtv ~]$ mythbackend
2006-10-11 12:43:32.792 Using runtime prefix = /usr/local
2006-10-11 12:43:32.802 New DB connection, total: 1
2006-10-11 12:43:32.807 Unable to connect to database!
2006-10-11 12:43:32.807 Driver error was [1/1045]:
QMYSQL3: Unable to connect
Database error was:
Access denied for user 'mythtv'@'mythtv' (using password: YES)
QSqlQuery::exec: database not open
QSqlQuery::exec: database not open
2006-10-11 12:43:32.866 DB Error (KickDatabase):
Query was:
SELECT NULL;
No error type from QSqlError? Strange...
2006-10-11 12:43:32.922 Failed to init MythContext, exiting.
[mythtv@mythtv ~]$
OK, I just tried it again by granting privileges EXACTLY as you suggested, and find it now works. BUT, I don't understand WHY. Shouldn't the mythtv@mythtv restrict my usage to that particular hostname?
Offline
The % char has special meaning in mysql (it means all host) but '%' is interpreted as an host with name %
Offline