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! 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
