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'
Whenever I do this on my own myth machines, I do it as root, like so:
$ mysql -u root mythconverg
See also, the very last section of this page:
<http://www.mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2>
-ajb
--
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
