[mythtv-users] MySQL nightmare setting up MythTV

Intense Red intnsred at golgotha.net
Wed Jun 14 14:32:56 UTC 2006


 > going on, but every time I try to connect it says "| #1045 - Access
 > denied for user 'root'@'192.168.0.8' (using password: YES) |".

   I ran into a similar problem to this; two things were needed to solve it:

1) Go into /etc/mysql/my.cnf and change the bind-address parameter to your IP 
address.  That one was easy to find.  The more difficult one to find was:

2) I had to use phpMyAdmin to clone the MySQL root user creating one to be 
able to log in from my own IP address (e.g. from 192.168.0.8 -- just 
localhost won't cut it).

 Regards.

-- 
"The world's 500 richest people have more money than the annual earnings of 
the poorest 3 billion." -- George Monbiot.


More information about the mythtv-users mailing list