[mythtv-users] Newbie Help Please!! Mandriva 2006 mysqld and mysql neither working

[scott at tbwifi.ca]

>>
>>
>>     Quoting scott at tbwifi.ca:
>>
>>    > I have been trying to deal with problems that I am having with
>> MySQL on
>>> Mandriva 2006. I am using MySQL for Mythtv. After installing and
>>> uninstalling various versions of MySQL trying to make things work I
>> now
>>> have version 4 installed. 40-4.0.26-1 to be exact. I've installed
>> MySQL,
>>> MySQL-client, and MySQL common. Now I believe that I have a mess
>> because
>>> in services there is a listing for mysql and mysqld. Neither of
>> them seem
>>> to want to start or stop cleanly and show up as [FAILED] in MCC
>> services.
>>> How do I clean things up so that I can start the server and connect
>> to it?
>>> Note if you didn't figure it out I am definitely a newbee to this
>> stuff,
>>> but I was albe to make things work on my previous installation of
>> Mythtv.
>>> If anyone has some pointers I would sure appreciate it. I am at a
>>> standstill.
>>>
>>> Thx!
>>> Scott
>>> _______________________________________________
>>> mythtv-users mailing list
>>> mythtv-users at mythtv.org
>>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>>
>>
>>    Scott-
>>
>>    So is your mysql server running (try  #/sbin/service mysqld status)
>> if your server is running then you can try to login manualy with a
>> command like:  $mysql -h localhost -u mythtv -pmythtv mythconverg  If
>> you can log into the mysql server then your goldin. if the server is
>> not running, what are the logs?  can you reinstall mysql (uninstall &
>> reinstall)?  do you have anydata in the mysql server at this time?
>>
>>    let me know
>>
>>    -Matt
>>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>
>
> Thanks for the reply...
>
> Is server running --> mysqld dead but subsys locked
> Attempt to login  --> ERROR 2002: Can't connect to local MySQL server
>          through socket '/var/lib/mysql/mysql.sock' (2)
> Logs --> assuming that you mean /var/log/mysqld/mysqld.log...it is empty
> I have already uninstalled and reinstalled a few times and even installed
> an older version of mysql thinking that was the problem.  I also deleted
> the files in the mysql directory thinking that the permissions file my
> offering some trouble with logging in.  I did that before a fresh
> re-installation.  Perhpas I corrupted something.  Note that the only way a
> can seem to clear things up after trying to start up the server
> unsuccessfully is with a reboot.  I'm sure that's just the newbee talking.
>  Surely there is another method.  Anyhow, I'm still hanging and any
> further advice is definitely appreciated.  BTW the database is emply as I
> haven't been able to log in to configure it yet.
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

Okay, here is some further info...
I did another removal of all packages with sql in the name.  Interesting
after a reboot a mysqld still shows up in services within the MCC GUI. 
However the 'mysql' that used to be listed alongside 'mysqld' is no longer
there so it must have been related to the older revision number.  I
reinstalled the original default revision by urpmi mysql hoping that I
could fix the corruption.  No such luck.  Upon trying to start the mysqld
service I get a timout error.  What can I do to complely clear out all the
old mess from the corrupted install?

Scott