[mythtv-users] Database problem?

[Peter Crighton]

On Fri, 6 Oct 2006 15:59:07 +0100, you wrote:

>On Fri Oct 06, 2006 at 10:26:19AM -0400, list at onnow.net wrote:
>

>> 
>If that works, you should then do:
>        mysql mythconverg -h mythtv -u mythtv -pmythtv
>
>This will verify whether your hostname (mythtv) is causing the issue.
>If it is, then it may be that your database has the networking disabled
>or limited to localhost (check /etc/mysql/my.cnf, or wherever your
>distro puts this file).
>

OK, This fails: Error 2003 (HY000): Can't connect to MySQL server on
'mythtv' (111)

The contents of/etc/my.cnf  is:


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Default to using old password format for compatibility with old and
# shorter password hash.
# Reference: http://dev.mysql.com/doc/mysql/en/Password_hashing.html
old_passwords=1
     
[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid



(It may be an obvious problem - I'm fairly expert at Windows and just
learning with Linux)
--

Peter Crighton