[mythtvnz] I killed MYSQL now what?

[David Moore]

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.