<html><head><style type='text/css'>body { font-family: 'Times New Roman'; font-size: 12pt; color: #000000}</style></head><body><br>----- Original Message -----<br>From: "Damian Surr" <damian@gingermagic.co.uk><br>To: "Discussion about mythtv" <mythtv-users@mythtv.org><br>Sent: Friday, March 9, 2007 12:59:47 PM (GMT-0700) America/Denver<br>Subject: [mythtv-users] My MySql hell :-)<br><br><title></title>
<div>
<font face="Helvetica, Arial, sans-serif"><br>> Database error was:<br>> Access denied for user 'mythtv'@'192.168.0.2' (using password: YES)<br><br>this error says that you do not have access to that account from that host. i.e. the mythtv client is telling the mysql server that 'mythtv' is connecting from '192.168.0.2' and mysql is telling you that mythtv is not allowed to connect to the service from 192.168.0.2.<br><br>what you need to do is allow access from 192.168.0.2. you can do this by logging in to the mysql server using the root account and running the following command:<br><br></font><pre class="programlisting"><strong class="userinput"><code>GRANT ALL PRIVILEGES ON *.* TO 'mythtv'@'192.168.0.102'</code></strong> <strong class="userinput"><code>IDENTIFIED BY 'some_pass' WITH GRANT OPTION;<br>flush privileges;<br></code></strong></pre>whatever you use for 'some_pass' needs to be in the mysql.txt file. you can make it easy and use 'mtythtv'.<br><br><font face="Helvetica, Arial, sans-serif">
<br></font><font face="Helvetica, Arial, sans-serif"><br>> $ mysql -u root mysql<br>> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using <br>> password: NO)<br>
<br>this is a problem. you probably won't be able to update the user table with the mythtv account. i do not know what default password you get with your distro; however, on some it is just blank. you can try a simple <enter> when prompted for a password.<br><br></font></div><br>-- <br>Peter Abplanalp<br></body></html>