Just another note.. I did use http://wilsonet.com/mythtv/fcmyth.php#mysql to set this up...
I did receive the error that is mentioned here.. Could this be the issue? > From: Michael Jones <[EMAIL PROTECTED]> > Reply-To: Discussion about mythtv <[email protected]> > Date: Fri, 01 Jul 2005 17:19:47 -0700 > To: Discussion about mythtv <[email protected]> > 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
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
