Lan Barnes wrote: > On Mon, May 14, 2007 4:16 pm, Mark Schoonover wrote: >> Lan Barnes wrote: >>> On Mon, May 14, 2007 3:26 pm, Mark Schoonover wrote: >>>> >>>> >>>> Lan Barnes wrote: >>>>> I have a mySQL DB on a machine. It is supposed to serve across a >>>>> network. I can log into it with >>>>> >>>>> mysql -u mythtv -p -h localhost mythconverg >>>>> >>>>> but not with >>>>> >>>>> mysql -u mythtv -p -h xena mythconverg >>>>> >>>>> No joy with xena's dotted quad. >>>>> >>>>> If I add xena to the loopback line in /etc/hosts as another >>>>> nickname, it connects, but of course, doesn't really make it >>>>> available across the network. >>>>> >>>>> I have tried putting >>>>> >>>>> bind_address=xena >>>>> >>>>> into /etc/my.cnf with various permutations such as bind-address, >>>>> the IP address, and in various sections of the file. >>>>> >>>>> Any tips? >>>>> >>>>> TIA, >>>>> >>>>> -- >>>>> Lan Barnes >>>>> >>>>> SCM Analyst Linux Guy >>>>> Tcl/Tk Enthusiast Biodiesel Brewer >>>> >>>> You have to grant the rights to the ip address, or entire subnet >>>> you want to have access the mysqld, even if you're connecting from >>>> the same machine. MySQLd determines access privileges based on >>>> host, then username: >>>> >>>> GRANT ALL on mythconverg.* to 'mythtv'@'%' IDENTIFIED by >>>> 'password'; >>>> >>>> That will let user mythtv from any host/subnet have access to the >>>> mythconverg database. Login via: >>>> >>>> mysql -u mythtv -p -h localhost mythconverg, then run the GRANT >>>> command above. >>>> >>>> Thanks! >>>> >>>> Mark Schoonover *** Winner of the 2008 Best Psychic Award >>>> IS Manager, CMDBA >>>> American Geotechnical - California, Nevada and Arizona >>>> V-> 858.450.4040 F-> 714.685.3909 C-> 858.472.3816 >>>> >>> >>> I hate to come running back to daddy, but ... >>> >>> [EMAIL PROTECTED] ~]# mysql -u mythtv -p -h localhost 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 6 to server version: 5.0.27 >>> >>> Type 'help;' or '\h' for help. Type '\c' to clear the buffer. >>> >>> mysql> GRANT ALL on mythconverg.* to 'mythtv'@'%' IDENTIFIED by >>> 'password'; ERROR 1044 (42000): Access denied for user >>> 'mythtv'@'localhost' to database 'mythconverg' >>> >> >> Does mythtv have the GRANT OPTIONS set for localhost?? Doesn't look >> like it. SHOW GRANTS FOR CURRENT_USER; You're looking for WITH >> GRANT OPTION. If that's missing, then there should be >> 'root'@'localhost' user that will have WITH GRANT OPTION. >> >> Thanks! >> > > I managed to pound it into submission. Some more scut work defining > capture cards and inputs, and I should be clear to test. > > Thanks to all. > > BTW, myth-users has ... well, not kicked me off, but firmly > discouraged MythDora users from posting questions. Don't know why. > Ubuntu, to pick one, seems welcome. The MythDora forum is s*l*o*w to > respond. Kplug has the best and most accurate data with the best > turnaround time.
And we won't charge you much! :) Thanks! Mark Schoonover *** Winner of the 2008 Best Psychic Award IS Manager, CMDBA American Geotechnical - California, Nevada and Arizona V-> 858.450.4040 F-> 714.685.3909 C-> 858.472.3816 -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
