[mythtv-users] mythfrontend can't connect to backend/database

[R. G. Newbury]

starcycle wrote:

> 2008-04-20 14:23:50.046 Testing network connectivity to 192.168.0.103
> 2008-04-20 14:23:50.106 Unable to connect to database!
> 2008-04-20 14:23:50.107 Driver error was [1/2013]:
> QMYSQL3: Unable to connect
> Database error was:

Using perror:
root at myth ~]# perror 1
OS error code   1:  Operation not permitted


Which means it is likely that /tmp is owned by root:root and mysql 
cannot talk to the socket.

Edit the /etc/my.cnf file to point mysql to somewhere it can write to..
This is the top of my file:

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

/Var/lib/mysql is owned by mysql and of course it can write there!

Geoff