<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hi. I have one combined frontend/backend and one remote frontend all running Ubuntu 10.04 (Lucid Lynx). My combined machine works fine, but my remote frontend can not access my mythconverg database. My setup was working fine before, but after upgrading from Ubuntu 9.10 to 10.04, I have been unable to remotely access the database. I realize that this has been discussed before, but I've implemented all of the fixes that I could find and I still have access problems. Hopefully someone can tell me what I missed.<br><br>Here are some details: the following command (being run on the combined frontend/backend) works fine to give me access to the mythconverg database:<br>$ mysql -u mythtv -p -h localhost mythconverg<br><br>However, altering the hostname to the host's IP address on the same combined frontend/backend machine gives an error:<br>$ mysql -u mythtv -p -h 192.168.2.103 mythconverg<br>Enter password: <br>ERROR 1045 (28000): Access denied for user 'mythtv'@'supicomp.local' (using password: YES)<br><br>My /etc/mysql/my.cnf file is the standard Ubuntu 10.04 (Lucid) default file with only the bind-address being altered:<br># Instead of skip-networking the default is now to listen only on<br># localhost which is more compatible and is not less secure.<br>bind-address = 0.0.0.0<br>The "skip-networking" command is not my.cnf.<br><br>I have granted permissions to user mythtv for the mythconverg database by executing:<br>$ mysql -u root mythconverg<br>mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";<br>mysql> flush privileges;<br><br>I'm not fully sure what netstat actually does, but I've seen references to using it for diagnostic purposes. Here is what I get:<br>$ netstat -ln | grep mysql<br>unix 2 [ ACC ] STREAM LISTENING 4993 /var/run/mysqld/mysqld.sock<br><br>Finally, nmap tells me that the default mysql port is listening:<br>$ nmap 192.168.2.103 | grep mysql<br>3306/tcp open mysql<br><br>If anyone can tell me what further troubleshooting I should perform or how I can fix this problem, that would be much appreciated.<br><br>Thanks,<br> Sunil <br /><hr />The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. <a href='http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5' target='_new'>Get busy.</a></body>
</html>