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. -- Lan Barnes SCM Analyst Linux Guy Tcl/Tk Enthusiast Biodiesel Brewer -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
