Mythtv lacks permission to log in. Try reading this: http://dev.mysql.com/doc/mysql/en/adding-users.html
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael Jones Sent: Friday, July 01, 2005 7:20 PM To: Discussion about mythtv Subject: Re: [mythtv-users] Frontends can't find database, can't connect Ok.. this is getting a little frustrating.. Sorry if this is a little disjointed.. but my brain is bouncing around in my head trying to wrap itself around this properly ;) Note: >From the machine running the masterbackend I can only access the database as root.. not mythtv as I am assuming I should be. Everything *SEEMS* to work as root.. but maybe not really. I can't log into mysql from the command line at all as 'mythtv' Transcript: ... [EMAIL PROTECTED] database]# mysql -u root -p mythconverg Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 84 to server version: 3.23.58 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select * from user where User = 'mythtv'; ERROR 1146: Table 'mythconverg.user' doesn't exist mysql> Kinda weird. Mysql says I don't have a table called 'user' (tried 'users' too)???? ------------------------------------------------------------ /etc/my.cnf file ------------------------------------------------------------ [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock set-variable = key_buffer = 16M set-variable = table_cache = 128 set-variable = sort_buffer = 2M set-variable = myisam_sort_buffer_size = 8M #bind-address = 192.168.0.40 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid ------------------------------------------------------------ if uncomment the bind-address entry into the mysqld area, mysqld won't start up. Is this a mysql4 command.. I'm still on 3 it appears. I've tried different variations with no changes The only attempt that allowed me to start mysqld was to put the bind-address=x.x.x.x in the [mysql.server] section, but it didn't change the final outcome at all. the error that I get from the mythtv-setup and mythfrontend entries are: QMYSQL3: Unable to connect Database Error Was: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I get the same result from other machines (a Windows machine running WinMythtv and a MacOSX 10.4 (tiger) machine running MacMythtv frontend. I've also tried setting it to connect as root (just for giggles) with the same result. I've also tried the security setup described in http://www.mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2 with no joy (Tried all 3 levels.. none, domain level security and ip address security). It almost seems as though the mythconverg database is all fubar'd.. but it might be something simple.. Help? - Michael > From: Korey Fort <[EMAIL PROTECTED]> > Reply-To: Discussion about mythtv <[email protected]> > Date: Fri, 1 Jul 2005 03:09:15 -0500 > To: 'Discussion about mythtv' <[email protected]> > Subject: RE: [mythtv-users] Frontends can't find database, can't connect > > > You can try mysqlaccess mythtv to see what access mythtv has or > Log into mysql then use mysql; select * from user where User = 'mythtv'; > This will show you where mythtv is allowed to connect from. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Michael Jones > Sent: Friday, July 01, 2005 2:30 AM > To: Discussion about mythtv > Subject: [mythtv-users] Frontends can't find database, can't connect > > When I try to configure a remote frontend (I've tried another FC3 box, a Mac > OSX box.. haven't tried the Windows front end yet) it tells me that it can't > find the database. > > The messages that come up on screen say that the current user isn't allowed > to connect to the remote machine.. > > I'm not sure where to start looking for a solution to this. > > Is there some portion of mysql that may not be running (i.e. the server?) > when mysqld is started? > > Any ideas. > > Thanks Much. > > - Michael > > > > > _______________________________________________ > mythtv-users mailing list > [email protected] > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
