I'm having a mysql permissions problem. I know "the usual" way to deal with this, but it doesn't seem to be working for me in the case. Here is a log of an interaction with mysql. I don't really understand how I can possibly get an error in the last command. If anybody sees what I'm missing, please let me know:<br>
<br>First, I start by just demonstrating the problem:<br><br><div style="margin-left: 40px;"><span style="font-family: courier new,monospace;">mtiller@mythtv:/home/mythtv/.mythtv$ <b>mysql -h192.168.11.110 -umythtv -p</b></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Enter password: </span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">ERROR 1045 (28000): Access denied for user 'mythtv'@'mythtv' (using password: YES)</span><br>
</div><br>Note the host in that case is by IP address. I'm trying to access it that way because I want to be able to access it through my LAN and I'm simulating the LAN access problems I've been having. Note that everything is fine if I access it via localhost, e.g.<br>
<br><div style="margin-left: 40px;"><span style="font-family: courier new,monospace;">mtiller@mythtv:/home/mythtv/.mythtv$ <b>mysql -hlocalhost -umythtv -p</b></span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Enter password: </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Welcome to the MySQL monitor. Commands end with ; or \g.</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Your MySQL connection id is 1342</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Server version: 5.1.41-3ubuntu12 (Ubuntu)</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.</span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">mysql> </span><br style="font-family: courier new,monospace;"></div><br>So this looks like a permissions issue so I get in as root and grant some pretty broad permissions:<br>
<br><div style="margin-left: 40px;"><span style="font-family: courier new,monospace;">mtiller@mythtv:/home/mythtv/.mythtv$ <b>mysql -hlocalhost -uroot -p</b></span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Enter password: </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Welcome to the MySQL monitor. Commands end with ; or \g.</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Your MySQL connection id is 1042</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Server version: 5.1.41-3ubuntu12 (Ubuntu)</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.</span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">mysql> <b>grant all on mythconverg.* to mythtv@"%" identified by "mythtv";</b></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Query OK, 0 rows affected (0.00 sec)</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">mysql> <b>flush privileges;</b></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Query OK, 0 rows affected (0.00 sec)</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">mysql> Bye</span><br>
</div><br>I must be missing something because I would then expect this to work, but it doesn't:<br><br style="font-family: courier new,monospace;"><div style="margin-left: 40px;"><span style="font-family: courier new,monospace;">mtiller@mythtv:/home/mythtv/.mythtv$ <b>mysql -h192.168.11.110 -umythtv -p</b></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Enter password: </span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">ERROR 1045 (28000): Access denied for user 'mythtv'@'mythtv' (using password: YES)</span><br>
</div><br>I even tried specifying the database in case that was the issue:<br><br style="font-family: courier new,monospace;"><div style="margin-left: 40px;"><span style="font-family: courier new,monospace;">mtiller@mythtv:/home/mythtv/.mythtv$ <b>mysql -h192.168.11.110 -umythtv -p mythconverg</b></span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">Enter password: </span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">ERROR 1045 (28000): Access denied for user 'mythtv'@'mythtv' (using password: YES)</span><br>
</div><br>There doesn't seem to be any issue with the command. It seems to be pretty clear that this is an authorization issue. I just don't understand why since I allow the user "mythtv" from anywhere so why should changing the host make a difference?<br>
<br>This is definitely the local machines IP address, e.g.<br><br><div style="margin-left: 40px;"><span style="font-family: courier new,monospace;">eth0 Link encap:Ethernet HWaddr 90:fb:a6:4d:a5:fd </span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"> inet addr:192.168.11.110 Bcast:192.168.11.255 Mask:255.255.255.0</span><br style="font-family: courier new,monospace;"></div><br>Furthermore, I've tried changing /etc/mysql/my.cnf to change the bind address. I've tried commenting out and explicitly setting it to 127.0.0.1, 0.0.0.0 and 192.168.11.110 (with a restart after every change). There is no "skip-networking" option in my.cnf (anymore), that is why I'm messing with bind-address.<br>
<br>I'm hoping a second set of eyes (or somebody who knows more about MySQL security) can spot what I'm missing. Thanks.<br><br>--<br>Mike<br><br>