Re: MYSQL server, access denied
unutbu - I found the folders where you said they were, so that worked out. I realized that what I was looking for was a text file version of that...but now I remember that I got that through a back-up utility and is only needed for a certain set of situations...bottom line - I think I've got what I need as far as that goes now. Thanks!
DaithiF - On the master backend/frontend, things now seem to be working as they should. Mission accomplished there. However, I have three remote frontends that had all been working fine on the old system that are not able to connect now. All of them had been set up with an ip address (192.168.1.47) instead of a server name, and that had been working. The IP address has not changed at all, nor has the user name/password information.
Additionally, I was looking at the mysql.txt of the old (working) partition (I have it in a backup folder on this side, and the entire file consisted of:
Code:
DBHostName=<host name here>
DBUserName=mythtv
DBName=mythtv
DBPassword=<password here>
The one on this partition is:
Code:
DBHostName=localhost
# By default, Myth tries to ping the DB host to see if it exists.
# If your DB host or network doesn't accept pings, set this to no:
#
DBHostPing=no
DBUserName=mythtv
DBPassword=<passowrd here>
DBName=mythtv
DBType=QMYSQL3
# Set the following if you want to use something other than this
# machine's real hostname for is....etc, etc, etc....
I realize that the majority of that is just commented out info, but for giggles, I created a back-up of this partition's file and then edited it to be the same as the other...still no luck.
So, summary:
Masterbackend: groovy
Remote frontends: No settings changed, but they cannot connect.
(I appreciated everyone's help, BTW.)
AMD Athlon 64 X2 4400+ 2.3GHz Dual Core, ASUS ATX AMD Motherboard, CORSAIR 4GB RAM, EVGA 512MB GeForce 9500 GT, 1.5TB mirrored RAID, 30GB primary drive, pcHDTV and Hauppauge 1600 tuners. Yeah, this hasn't been accurate for a long time.
Bookmarks