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

[scott at tbwifi.ca]

> Matt,
>
> I too am running Mandriva LE2006 with myth.  Are you familiar with the
> urpmi command?  If not, go to http://easyurpmi.zarb.org/ and set up your
> sources.
>
> As for mysql, here is what I have installed on my system:
>
> I got this by typing: rpm -qa | grep -i mysql
> perl-DBD-mysql-3.0002-1mdk
> php-mysql-5.0.4-1mdk
> MySQL-4.1.12-4.8.20060mdk
> libqt3-mysql-3.3.4-23mdk
> mysql-administrator-1.0.22a-1mdk
> MySQL-common-4.1.12-4.8.20060mdk
> libmysql14-4.1.12-4.8.20060mdk
> MySQL-python-1.2.0-1mdk
> MySQL-client-4.1.12-4.8.20060mdk
>
>
> If you install this using urpmi, I believe it automatically activates
> the service.  You can check by typing: chkconfig mysqld list .
>
> Here is the output on my system for that command...
> mysqld          0:off   1:off   2:on    3:on    4:on    5:on    6:off
>
> Also, check for the existance of /etc/sysconfig/mysqld
>
> If I can be of any more help, let me know...
>
> Rick
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

Thx for the reply Matt.  I've finally resolved this mess!

I am posting this for the benefit of others.  This seems to be the fix for
Mandriva 2006 and MySQL 4.1.12, but could be of use for other distros. 
Remove all sql related packages.  I used the GUI within the Mandriva
Control Center (MCC) and searched for sql.  Removed all packaged found in
the search.

Remove the lock

# rm -f /var/lock/subsys/mysqld

Delete the mysql file and directories.  Make sure that you don't have any
important database files in here. If you do, move them.  Note that these
two items will be re-installed in the next step.

# rm -rf /var/lib/mysql
# rm /etc/my.cnf

Now reinstall everything you removed previously.  Any required
dependencies will need to be added as well.

# urpmi mysql mysql-client mysql-common libqt3-mysql

That’s it.  All should be well.

Here’s a related post that helped my overcome this mess.

Problem with MySql - LinuxQuestions.org
<http://www.linuxquestions.org/questions/showthread.php?t=262262