[mythtv-users] Upgrade to 2.6.17-gentoo-r2/ivtv-0.7.0/mythtv-0.19_p9163-r1 and having problems

[John Johnson]

Michael T. Dean wrote:
> On 07/16/06 15:29, Mark Knecht wrote:
>
>   
>> On 7/16/06, Michael T. Dean <mtdean at thirdcontact.com> wrote:
>>  
>>
>>     
>>> On 07/16/06 14:28, Mark Knecht wrote:
>>>
>>>       
>>>> dragonfly ~ # mysql -u root mythconverg
>>>> ERROR 2002 (HY000): Can't connect to local MySQL server through socket
>>>> '/var/run/mysqld/mysqld.sock' (111)
>>>>      
>>>>
>>>>         
>>> Do you have the --skip-networking option in your commandline or in your
>>> MySQL configuration file?
>>>
>>>       
>> I assume this is not a mysql permissions issue since I need to connect
>> to change permissions?
>>
>> skip-networking is commented out in both /etc/conf.d/mysql and
>> /etc/mysql/my.cnf
>>
>>     
>
> >So, does the file /var/run/mysqld/mysqld.sock exist?  If not, make sure 
> >the user who's running mysqld has permissions to write to it and then 
> >restart mysql.
>   
Didn't get the beginning of this thread, but you can eliminate the 
socket errors by specifying the host on the command line. Such as:

If your server is in your /etc/hosts (or otherwise defined):
mysql -uroot -ppassword -hserver mythconverg

If not, use its numeric IP address:
mysql -uroot -h192.168.0.100 mythconverg


Regards,
  JJ