Mike, Follow this yggdrasil ~ # mysql -uroot -p mysql> show databases; mysql> use mysql; mysql> select * from user where User = 'mythtv';
you should see atleast 2 records | % | mythtv | localhost | mythtv If you do not see the % one create a the user GRANT USAGE ON *.* TO 'mythtv'@'%' IDENTIFIED BY 'mythtv'; % is the one that would allow the user to connect from a remote location You say root can connect remotely so I do not thing the bind address needs to be changed. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:mythtv-users- > [EMAIL PROTECTED] On Behalf Of Michael Jones > Sent: Friday, July 01, 2005 8: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
