<div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">I edited my /etc/mythtv/mysql.txt file to show the proper server address as shown...<br>
<div class="Ih2E3d"><br>
user=mythtv<br>
password=C1RFOKlE<br>
database=mythconverg<br>
</div>server=<a href="http://127.0.0.1" target="_blank">127.0.0.1</a><br>
<br>
I then entered these settings into the "live session configuration" window.<br>
<br>
At this point I am given the option of testing the connection, which always fails.<br>
<br>
Now I will study the rest of your letter and try to make sense of it. I am afraid that this is just too deep for me. So many names and passwords. And then the need to access databases and setup files. I don't understand why, if these steps are needed, why doesn't the setup process prompt me for these steps instead of assuming I am smart enough figure out what I need to do?<br>
<br>
Thank all of you for your help. I really do appreciate it. But I feel guilty for tackling a subject that I obviously am not up to dealing with and then having to depend on you guys to bail me out.<br>
<div class="Ih2E3d"><br>
</div></blockquote></div><br>MythTV keeps all of the settings and information about all of your recordings in a mysql database. Mysql has a root user that can create other mysql users and change settings, etc. I am not sure but I think you are having the same problem I had on another machine. When you set up mythtv originally you used the ip address of the machine instead of 'localhost' or '<a href="http://127.0.0.1">127.0.0.1</a>'. By default mysql is setup to only allow connections from localhost. So when you used the machines ip address the connection appears to come from the network and is rejected. This means that the setup program wasn't able to create the mysql user named 'mythtv', and it wasn't able to create the database (named mythconverg) that stores all of the mythtv settings. So when you try to fire up mythtv it tries to connect to the database with the info from /etc/mythtv/mysql.txt, however that mysql user and database were never actually created and the connection is rejected. I don't really know anything about mysql other than what I have had to do with mythtv. So I may be wrong about all of this, but it is what the best guess I had after digging around when I had this problem. <br>
<br>You can test things out by logging into mysql from the command line like this:<br><br>mysql -u mythtv -p mythconverg<br><br>I think the password should be the one stored in /etc/mythtv/mysql.txt. If this doesn't work, then you have the wrong password or the user and database never got created (as I explained above). You can try running 'sudo dpkg-reconfigure mythtv-database' to setup the database again. This will prompt you for some info. Use the following, mysql address: 'localhost', mysql administrator account: root, password: <leave blank> (this is the default unless you changed it), I believe this will setup your mythtv user in mysql and create the mythconverg database. After it is done you can try logging in from the command line again and see if that works. If you can get things right, so that you can log in from the command line then mythtv should have no problem connecting. <br>