[mythtvnz] I killed MYSQL now what?

[Steve V]

>________________________________
> From: David Moore <dmoo1790 at ihug.co.nz>
>To: mythtvnz at lists.linuxnut.co.nz 
>Sent: Saturday, 2 June 2012 12:42 PM
>Subject: Re: [mythtvnz] I killed MYSQL now what?
> 
>On 02/06/12 07:00, Steve V wrote:
>>
>>     Ok I have moved on, I
>>
>>     sudo apt-get purge mysql-server
>>     and sudo apt-get purge mysql-client
>>     and sudo apt-get purge mysql-common
>>
>>     and I also deleted /etc/apparmor.d/usr.sbin.mysqld
>>
>>     before reinstalling.
>>
>>     it now seems that mysql is running, but now I am still having
>>     trouble with restoring my mythtv database.
>>
>>     I guess it may be database password related but I am not sure.
>>
>>     /usr/share/mythtv/mythconverg_restore.pl --verbose --directory
>>     /mythtvstorage3/recordings --filename
>>     mythconverg-1264-20120527075514.sql.gz
>>
>>     Configuring environment:
>>     - username: steve
>>     - HOME: /home/steve
>>     - MYTHCONFDIR: /home/steve/.mythtv
>>
>>     Parsing configuration files:
>>     - checking: /home/steve/.mythtv/config.xml
>>     parsing: /home/steve/.mythtv/config.xml
>>     - checking: /home/steve/.mythtv/backuprc
>>
>>     Applying command-line arguments.
>>
>>     Checking configuration.
>>
>>     Database Information:
>>     DBHostName: 10.1.1.11
>
>
>Is this the problem? Port number should be 3306. Also IP address should 
>be 127.0.0.1? See below.
>
>
>>     DBPort: 0
>>
>>
>>
>>
>>     mysql -u mythtv -p C1RFOKlE mythconverg
>>
>>     gives
>>
>>     mysql Ver 14.14 Distrib 5.1.62, for debian-linux-gnu (i686) using
>>     readline 6.2
>>     Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights
>......
>>     Variables (--variable-name=value)
>>     and boolean options {FALSE|TRUE} Value (after reading options)
>>     --------------------------------- -----------------------------
>>     port 3306
>
>On my system the port number is set in /etc/mysql/my.cnf.
>
>Also I think you should use the loopback address 127.0.0.1 if that's 
>what the bind-address is set to in /etc/mysql/my.cnf.
>
>_______________________________________________
>mythtvnz mailing list
>mythtvnz at lists.linuxnut.co.nz
>http://lists.ourshack.com/mailman/listinfo/mythtvnz
>Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/
>
>Yes you are correct, I fixed (at least I think it is fixed), by first changing the root mysql password, then changing the mythconverg password.
>
>
>Then I changed my.cnf so mysql binds on 10.1.1.11 cos I don't know how to make myth connect to 127.0.0.1.
>
>
>Looks like everything is working except Mythweb is not accepting my password, so I will have to try and figure out how I protected it, from memory there are a few ways to do this. 
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ourshack.com/pipermail/mythtvnz/attachments/20120601/7397ca1d/attachment-0001.html>