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