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 -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
