[mythtv-users] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

[Jason Werpy]

> > is your mysql daemon running?
> > a 'ps aux | grep mysqld' should answer that
> >
> > on redhat/fedora use the /sbin/chkconfig command to have it run at the
> > runlevels you want
> 
> As I already stated in my initial post, MySQL is working fine:
> 
> > mysql -umythtv mythconverg -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 32 to server version: 4.0.21
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> 
> mysql>
> 
> Not that it really matters but I start mysqld from /etc/rc.d/boot.local:
> 
> /usr/local/bin/mysqld_safe --user=mysql --skip-bdb --skip-inno
> --datadir=/var/lib/mysql &
> 
> And yes it's running:
> 
> > ps aux | grep mysqld
> root     25651  0.0  0.2  2540 1192 ?        S    Sep26   0:00 /bin/sh
> /usr/local/bin/mysqld_safe --user=mysql --skip-bdb --skip-inno
> --datadir=/var/lib/mysql
> mysql    25683  0.0  0.6 15132 3116 ?        S    Sep26   0:00
> /usr/local/libexec/mysqld --basedir=/usr/local
> --datadir=/var/lib/mysql --user=mysql
> --pid-file=/var/lib/mysql/saturn.pid --skip-locking
> --socket=/tmp/mysql.sock --skip-bdb --skip-inno
> destiney  1846  0.0  0.1  2596  688 pts/0    S+   08:55   0:00 grep mysqld
> 
> 
> 
> 

Have you checked the settings in your mysql.txt file?  Its in the
share directory for myth.
This can be in different locations depending on your install, but its
either /usr/local/share/mythtv or /usr/share/mythtv generally.

mysql.txt contains connection information myth uses to connect to
mysql.  I have to reset the server information on my frontend every
time I do a new install as this file gets replaced.