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
Your reply so perfectly anticipates my needs that I con only conclude ... but you already knew that, didn't you? Thanks, just what I needed. -- Lan Barnes SCM Analyst Linux Guy Tcl/Tk Enthusiast Biodiesel Brewer -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
